December 13, 2010 at 9:58 am
Hi all
I just had a question about granting execute to a proc or function for a specified account. I would have thought that once granted the permission it would appear in the securables section for that user but it doesn't seem to. I am using SQL 2005 DEV edition SP3.
I have tried doing this through the GUI and using TSQL
Is this expected behaviour?
Thanks
December 15, 2010 at 8:29 am
No, I don't believe that's expected. When you grant exec rights, it should show under the Securables for that User.
December 15, 2010 at 8:37 am
In Management Studio make sure you're looking at the Database User, not the Server Login
or
SELECT o.[name], u.[name], p.permission_name
FROM sys.database_permissions p
INNER JOIN sys.objects o on p.major_id = o.object_id
INNER JOIN sys.sysusers u on p.grantee_principal_id = u.uid
WHERE u.[name] =
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply