Thursday, July 10, 2008

Create Role and Assign the user to the role

To Create a Role:

Create Role [role_name]

Responsibilities to the Role:

Grant Execute on sp_name to [role_name]
Grant select,insert,update,delete on table_name to role_name


Assign the user to the role:

exec sp_addrolemember N'role_name', N'login_name'

No comments: