I want to monitor an azure sql table for changes, what permissions are needed for the sql user?

petehall 20 Reputation points
2025-07-08T10:17:10.17+00:00

This is for Azure SQL. I have given the user select permissions on a specific table that has change trakcing enabled and also view database state permissions. However, it does not work. When I give the same user db_owner rights then it does. What permissions can i use to enable this monitoring without having to revert to the db_owner role?

Azure SQL Database

Answer accepted by question author
Saraswathi Devadula 16,040 Reputation points Microsoft External Staff Moderator
2025-07-08T14:38:31.73+00:00

Hello petehall

Following our discussion, you want to grant the permission to user so that they can access azure sql table for changes.

Kindly please run the below query to meet your requirement,
GRANT VIEW CHANGE TRACKING ON OBJECT::[YourTableName] TO [YourUser];

Was this answer helpful?

1 person found this answer helpful.
0 comments No comments

1 additional answer

Sort by: Most helpful
  1. petehall 20 Reputation points
    2025-07-08T14:42:58.0133333+00:00

    For clarity, Saraswathi answer above solved the issue. This is just a note for the earlier work config needed.

    Use grant select on the table that has change tracking enabled AND 'grant view change tracking on OBJECT::[tablename] to [user]'

    Was this answer helpful?

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.