Hi,
I'm trying to grant/deny object permissions in a user database using Enterprise Manager and query tool without success (for ‘public’ role and individual sql logins). I’m not getting any error messages. Permission changes just don’t take effect. Although, there are few objects, which already have permissions granted and I'm able to change permissions for these ones.
How can I change the permissions?
you might have a granted permission on a GUEST account
or an NT domain group. please check.
thats why denying wont work
|||there is no permissions granted or denied for the 'guest' account. I don't use domain groups.|||
What are the actual denies that you are trying to set. Did you verify that they appear in the system catalog (server_permissions, database_permissions)? Have you tried applying the denies using TSQL: DENY?
Thanks
Laurentiu
