hallz
asked on
How to create a Role based on an existing User in MSSQL 2005
I am in the process of tidying up our application/system accounts on our MSSQL 2005 server. We have an existing user account that has all the correct permissions for a few systems to access our main database.
What I need to do is create a new mssql role based on the user account (with all the same table/proc permissions) so that I can create a new role for each of the applications.
I can then migrate each application to its own account with the correct role and lock down the security on each to only what it needs.
I need help with writing some SQL I can run to do this or how to do it through sql manager?
What I need to do is create a new mssql role based on the user account (with all the same table/proc permissions) so that I can create a new role for each of the applications.
I can then migrate each application to its own account with the correct role and lock down the security on each to only what it needs.
I need help with writing some SQL I can run to do this or how to do it through sql manager?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Rimvis thats exactly what I was looking for!
Each database has a security node, where you can associate users and assign roles.
The server node also has a security node where you can create new accounts if need be.