New answers tagged

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'...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar

Top 50 recent answers are included