[Company Logo Image] 

Home Contents Coffee Break Credits Glossary Links Search

 Security
 

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
Tips
Troubleshooting
Tuning

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.