I am creating a database using SQL server express 2016 for a college project and
need to learn how to add a user whom can have access to all tables, however, only be able to alter one of the tables, update, delete, etc… I'm using sql server
express 2016 management studio
Sql-server – how can I add user who can read all tables in database and have permission to alter only one table
sql server
Related Question
- Sql-server – Grant access to all objects (with a few exceptions) to a role
- Sql-server – EXEC xp_dirtree
- SQLCLR C# Function Publishing Error in Visual Studio 2017
- Sql-server – MS SQL Server create user who can access only those databases which they have created
- Sql-server – User Does not have permission to alter database, the database does not exist, or the database is not in a state that allows access checks SQL server
- Sql-server – How to give access to a user on only two specified procedures and specified tables on SQL Server
Best Answer
Add the user to the db_datareader role within the database
Give the user permission to alter that single table
This will give the permissions you want. You could also create a specific database role with the correct permissions, or grant the user permissions on the schema so you should check the msdn article suggested by @randolph-west