April 16, 2003 at 10:30 am
Hello,
I am in the process of DENYing object permissions to the Guest account in the Master database for all permissions on all objects, and wondered if there is syntax I could use that would cover all objects and permissions, for the Guest user, at the same time instead of having to address permissions on each individual object. From what I have read about in BOL about DENY, it does not look like I can do this, but I thought I would check.
Thanks for your help!
CSDunn
April 16, 2003 at 11:24 am
You have to do explicit denies on each. Generally you want to do the grant/deny on a role, then drop the users into a role.
Might look in the script library, probably find something that sets permissions on all objects.
Andy
April 16, 2003 at 11:56 am
Please pardon the dumb question, but where is the 'Script Library' you referenced?
Thanks.
CSDunn
April 16, 2003 at 1:17 pm
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply