Add Database Role to Login Name

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joe K. - 27 Apr 2005 22:09 GMT

I have a SQL Server 2000 database that I restore often.

After the database is restored I need to add database security role to Login
Name Chicago\CH-datareader-K.

How would I add the database role 'db_datareader' to Login Name
Chicago\CH-datareader-K that correponds to User Name CH-datareader-K.

Please help me create the correct syntax so I add this to my restore script.

Thanks,

Reply to this Message

Jens Süßmeyer - 28 Apr 2005 06:26 GMT

Syntax
sp_addrolemember [ @rolename = ] 'role' ,
[ @membername = ] 'security_account'

So it should be

sp_addrolemember 'db_datareader','CH-datareader-K'

HTH, Jens Suessmeyer.

---

http://www.sqlserver2005.de

---

> I have a SQL Server 2000 database that I restore often.
>
[quoted text clipped - 9 lines]
>
> Thanks,

Reply to this Message