Security.

Minimum permissions required to create tables and views.
What are the minimum permissions a login can have to create tables and views on a database?

Permissions required to add logins to fixed database roles.
What are the minimum permissions a login can have to assign other logins to fixed database roles like db_datareader, db_datawriter, db_ddladmin?

Who created/modified/deleted an object on a database?
Do you ever wanted to know who created/modified/deleted a table, a stored procedure, an index, a view, a trigger on a database?





 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.