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'...
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 ...
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 ...
Top 50 recent answers are included
Related Tags
permissions × 1494sql-server × 645
postgresql × 245
mysql × 226
security × 158
oracle × 128
role × 121
sql-server-2012 × 112
sql-server-2008-r2 × 104
users × 87
sql-server-2014 × 75
stored-procedures × 65
schema × 62
sql-server-2008 × 59
sql-server-2016 × 53
logins × 50
view × 34
sql-server-agent × 33
t-sql × 28
ssms × 27
mariadb × 25
access-control × 25
amazon-rds × 23
database-design × 21
oracle-11g-r2 × 21