proper Roles and permission to use Azure Data Studio

Question

I am using Azure Data Studio. Which roles should I add to the user? There is an error when I use the Start New Profiler session:

The user does not have permission to perform this action.

score 1 · Accepted Answer · answered Mar 28 '20 at 05:34

1

To use Azure Data Studio SQL Profiler you may need to have Control permission over the database, The database owner has Control permission.

answered Mar 28 '20 at 05:34

Alberto Morillo

13,893
2
24
30

It worked but is it possible to give less permission? – Fatemeh Ramezani Apr 04 '20 at 19:32
No. It is not possible because Azure Data Studio SQL Profiler uses extended events and to run extended events you need Control permission. – Alberto Morillo Apr 05 '20 at 03:41

score 0 · Answer 2 · answered Nov 04 '21 at 06:55

0

It worked for me by granting VIEW SERVER STATE permission. This is a development server so it's not an issue for me if the user has more permission than it needs.

GRANT VIEW SERVER STATE TO [Username]

answered Nov 04 '21 at 06:55

SzilardD

1,611
2
22
40

score -1 · Answer 3 · answered Oct 03 '22 at 13:20

-1

To be able to execute a stored procedure for example you could do this:

GRANT EXECUTE ON [SCHEMA].[TABLE] to [USER]

answered Oct 03 '22 at 13:20

Lewi Uberg

1,055
7
14

This answer does not relate to the question. – Larry Silverman Jun 01 '23 at 15:09

proper Roles and permission to use Azure Data Studio

3 Answers3