Permissions grants, denies don't take effect

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

Permission editor?

Hi,
I wonder is there a tool for easy setting of custom permissions for user on
database. When i try to do this via the Enterprise Manager it shows all the
objects in the DB without any grouping so it's difficult set permissions.
For example if i want to give SELECT permissions on all tables but not to
give SELECT on the VIEWS and i want to give EXECUTE permission on all
functions i must go around the list and put check-s on the boxes manually.
Thanks in advance
Georgi Peshterski
I suggest you script your tasks instead of performing them from Enterprise
Manager. Take a look at
http://vyaskn.tripod.com/generate_sc..._sql_tasks.htm to find
some useful examples.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Georgi Peshterski" <unseen@.mail.bg> wrote in message
news:%233VrKC2aFHA.3040@.TK2MSFTNGP14.phx.gbl...
Hi,
I wonder is there a tool for easy setting of custom permissions for user on
database. When i try to do this via the Enterprise Manager it shows all the
objects in the DB without any grouping so it's difficult set permissions.
For example if i want to give SELECT permissions on all tables but not to
give SELECT on the VIEWS and i want to give EXECUTE permission on all
functions i must go around the list and put check-s on the boxes manually.
Thanks in advance
Georgi Peshterski