Approving Table access via workflows does not work in Microsoft Purview

Rajaniesh Kaushikk 476 MVP

Hi,

I saw a couple of demos on YouTube https://youtu.be/bpdb0x43eNQ where it is demonstrated that if the user tries to request access to the Synapse or Azure SQL DB table access and the approver approves the request requester can directly able to access the table. I have followed the same steps but after approving the request I am unable to access the table.

Any clue!!

Regards

Rajaniesh

PRADEEPCHEEKATLA-MSFT 77,336 Reputation points Microsoft Employee

2024-04-15T09:44:36.1566667+00:00

@Rajaniesh Kaushikk - Thanks for the question and using MS Q&A platform.

When you say you are unable to access the table- could you please share more details and any error message which you are experiencing?
PRADEEPCHEEKATLA-MSFT 77,336 Reputation points Microsoft Employee

2024-04-18T09:06:03.9933333+00:00

@Rajaniesh Kaushikk - We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Rajaniesh Kaushikk 476 Reputation points MVP

2024-04-20T11:41:38.43+00:00

I mean that requester unable to access the table with SSMS the way video is shown.
PRADEEPCHEEKATLA-MSFT 77,336 Reputation points Microsoft Employee

2024-04-22T03:47:49.1033333+00:00

@Rajaniesh Kaushikk - When you say requester unable to access the table- could you please share more details and any error message which you are experiencing?
Rajaniesh Kaushikk 476 Reputation points MVP

2024-04-27T06:10:23.46+00:00

PRADEEPCHEEKATLA-MSFT When the user who was granted the access to the table try to login to the database table with the help of SSMS it does not work. Access is denied.

Regards

Rajaniesh
Rajaniesh Kaushikk 476 Reputation points MVP

2024-04-27T06:11:30.5466667+00:00

PRADEEPCHEEKATLA-MSFT When user who is granted the access to the table tried to access the table via SSMS the access is denied.

Regards

Rajaniesh
PRADEEPCHEEKATLA-MSFT 77,336 Reputation points Microsoft Employee

2024-04-29T02:49:45.1466667+00:00

@Rajaniesh Kaushikk - Any access denied message will be having an error message which explains about the reason for the denial. Could you please share the error message to undertand and provide the solution accordingly?