question

sqlLearner 1 avatar image
sqlLearner 1 asked

dbo Permission Issue

I added a domain security group to my SQL Server logins. IN Active Directory I have added members to this group. My goal is to have this group have only read access to the DB. I have this working on other instances by assigning the db_datareader database role. With one of my instances the group is set to datareader but can't see any of the stored procedures within the DB. Looking further into it when I login as a member of the security group and check the the database level user "dbo" it has a red arrow on it as opposed to all the working instances the "dbo" user does not have this red arrow. Does anyone know how this can be resolved?
tsqlsecurityssmsloginusers
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Tim avatar image
Tim answered
If the user only has data reader access you will have to grant execute permissions on each of the stored procedures the group needs access to.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.