December 22, 2004 at 9:40 am
Hi,
I have a new login, which needs to get same permissions and access level as the one of the old logins. I dont want to script permissions and edit script for new login.
My Collegues who are Oracle DBA, are saying they can create in oracle using "Create Like", i was wondering if we have anything similar in SQL Server too.
Thanks for your help.
December 22, 2004 at 10:14 am
I think the best way to set security in any database is create (or use SQL Server) roles. That way you just create the user and assign the new user to a role, which will inherit the right permissions (check the SQL Server roles like Read and Write)
Good luck
December 22, 2004 at 10:49 am
Roles prevent this whole issue. You might find a script here on the site to help with this.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
December 23, 2004 at 12:15 pm
Implementing roles is very good advice; scripts that attempt to address the requirement are usually somewhat limited (especially if users may create database objects) Some procedures that may be of help include:
-- sp_HelpUser will return a list of all users of a given Database
Exec sp_HelpUser
-- sp_HelProtect will return user permissions for objects, TSQL statement permissions of a given Database.
Exec sp_HelProtect
-- sp_HelpRoleMember will return a list of all role members of a given Database.
Exec sp_HelpRoleMember
HTH
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply