New answers tagged permissions
0
votes
Accepted
Restrict access to a new schema to a specific role despite users having db_datareader?
Members of db_datareader can in fact read any table/view in any schema. Which is why it's often advised not to use this role if you need finegrained access control.
You could create a new 'common_read'...
- 188
0
votes
Grant All on All tabes in schema?
Right. You cannot GRANT the right to ALTER or DROP a table. Only the table owner or a superuser can do that.
The documentation describes that:
The right to modify or destroy an object is inherent in ...
- 32.1k
4
votes
Accepted
Error trying to add a login to Azure SQL Special Role 'dbmanager'
The dbmanager role is a database role not a server role. That database role only exists in the master database.
I.e., you have to create a user in the master database for the login in question and add ...
- 14k
Top 50 recent answers are included