Nick Strupat
Reputation: 5063
How do I give sysadmin right to a user for just one database in a SQL Server instance?
If I run this query, does that give sysadmin rights to the database the query is being run on or to all databases?
exec sp_addsrvrolemember N'username', sysadmin
Upvotes: 2
Views: 10079
Answers (1)
gbn
Reputation: 432271
sysadmin is SQL Server level admin so it would be all databases with no restrictions at all
You want db_owner in the database for one database
Upvotes: 2
Related Questions
- How to assign permission to a database user without using database role?
- Create user that can only SEE one database, and only select from it?
- GRANT a user to view single database? (deny viewing the rest)
- SQL Server - Create a new database for a user and ONLY give them access / view rights to that one DB
- SQLServer 2014 - have user access only one database
- Prevent windows admin user from reading a SQL Server database
- Create a user with permissions for only 1 database
- Setting up a user to my database in my SQL Server
- How do I prevent SQL Server sysadmin users write access?
- How to protect a database from the Server Administrator in Sql Server