Mauro Destro
Reputation: 766
Create db user with limited privileges
I have to create a sql 2008 database user that can backup and restore databases but NOT execute INSERT, UPDATE, DELETE.
Is it possible or the two operations are incompatible?
Upvotes: 1
Views: 407
Answers (1)
Raj More
Reputation: 48018
You will need to assign them the role of db_BackupOperator to the login(s) to be able to do this.
They will be able to see the objects, but not the data in them or the code behind them.
Upvotes: 2
Related Questions
- How do I create a user in SQL-Server that only has access to one table, and can only insert rows
- How to assign permission to a database user without using database role?
- SQL Server - Create user that can only read and write data from and to database
- Create SQL Server user with limited access
- How can I grant a user limited permissions in SQL Server 2008?
- Create user on database level
- Create a user with permissions for only 1 database
- Granting limited permissions to a user on SQL Server 2008
- Create user in SQL Server 2008
- Creating SQL users and restricting their permissions