My Profile Photo

Ashley Poole


- Speaker -
- Senior Software Developer -
- Co-organiser of @ShropshireDevs -
- Site Reliability Engineering Advocate -


T-SQL Add User To Role

SQL below to add a role to a user.

use MyDatabase;
go

sp_addrolemember 'db_owner', 'domainmyuser' ;
go

Posted on databases, knowledge-base with tags: sql-server

comments powered by Disqus