New answers tagged

5 votes

User can drop table from a schema, but cannot create one

As an owner of an object, you can DROP that object. Regardless of whether you have CREATE privileges for such an object. Schema owner implies CONTROL on the schema which implies ALTER on the schema. ...
0 votes

How to grant a user UNSAFE ASSEMBLY permission

USE master GRANT UNSAFE ASSEMBLY to [<login name>]
  • 131
-1 votes

postgresql grant user privilages to dynamically created tables

GRANT usage ON SCHEMA createuser TO consume; alter default privileges for user createuser in schema createuser grant select on tables to consume; This will work perfect.
  • 1
0 votes

Can not give NT SERVICE\MSSQLSERVER permissions on network drive

The accepted answer is wrong. The 'NT SERVICE\MSSQLSERVER' is not a local service account, it is virtual account. Virtual Accounts are running tasks in the context of the computer they are installed ...
  • 101
1 vote

Permission to grant SELECT, UPDATE, DELETE, ALTER on all tables

If you do not need those permissions, only the MyDbRole needs them - your DBA can grant permissions to this role directly, without you being the man in the middle, by running below code: use [...
0 votes

Permission to grant SELECT, UPDATE, DELETE, ALTER on all tables

There is not need to create the database role. You just need to add the user to the following 3 roles: -- db_datareader role will provide SELECT permissions on all tables EXEC sp_addrolemember '...
3 votes

How to migrate local windows users, groups and service accounts without causing orphaned users?

SID of windows domain logins can't be different between instances in the same domain, so there is no orphaned users when you copy logins from an instance to another and that's why you can't specify ...
  • 3,715

Top 50 recent answers are included