I have an AD group that is setup as a Windows Authenticated SQL Login on my SQL Server. On DatabaseA
it has the db_datareader
and public
roles. So the users of this AD group only have read access to the entities in the database.
Inside of DatabaseA
I have a stored procedure dbo.Proc1
on which I granted the execute
permission for the same AD group.
When a user of that AD group connects to this server, they don't see the entity dbo.Proc1
.
Is there any other permission I need to provide to the Windows Authenticated SQL Login (AD group) that I'm missing?
I do see, if I look at the properties of DatabaseA
, that there's an execute
permission at that level which has NOT been granted yet.
(Note: I only want the users of this AD group to have the ability to execute dbo.Proc1
. I don't want them to be able to do anything that isn't considered a "read-only" type of action.)