using sp_addrolemember

Posted by Derek Dieter on SQL Server Planet See other posts from SQL Server Planet or by Derek Dieter
Published on Fri, 04 Jun 2010 23:41:57 +0000 Indexed on 2010/06/05 6:04 UTC
Read the original article Hit count: 346

Filed under:
To add a user or group to a role, you need to use sp_addrolemember. This procedure is easy to use as it only accepts two parameters, the role name, and the username (or group). Roles are utilized in order to provide a layer of abstraction from permissions from being applied directly to users. While [...]

© SQL Server Planet or respective owner

Related posts about DBA