Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Removing Public Permissions... Expand / Collapse
Author
Message
Posted Monday, March 24, 2008 11:01 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, March 24, 2008 1:20 PM
Points: 1, Visits: 5
I apologize ahead of time for sounding like a complete idiot about this. I don't really know how things are setup exactly. However, I was put in charge of figuring out how to create a new role with all the same permissions that "public" has and then to remove all permissions from the Public role.

I have no idea how to do this. So I figured I would try posting this question to all you fine people who know what they are doing.

Please, any help would be much appreciated as I am in a time crunch also to get this done asap (like the end of this week).

Thank you,
Kenneth W. Cronin
ken-w.cronin@compuware.com
Software Developer
Compuware Corporation
Post #473598
Posted Monday, March 24, 2008 1:28 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, November 08, 2013 11:39 AM
Points: 16, Visits: 325
Ken,
Try here:
http://www.databasejournal.com/features/mssql/article.php/1478701

Even has a script to download to copy permissions from a group.

Now, That being said, question the task, it will make you all the wiser. If my 4 yr old came to me and asked for scissors, I would not "just do the task" and give her scissors. Ask what the requirements are, if what you are trying to do is accomplished by the task, then great but at least you will know you are doing the right thing and maybe even make a suggestion or learn how to do it better.. ;)


_______________________________________________________________________
Work smarter not harder.
Post #473678
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse