 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / General / Security / January 2008Create PK / FK Tables Security
I have several SQL Server 2005 databases on my server. What SQL Server 2005 security role has the least priviledges to complete the following capabilities? Able to create tables, triggers, create primary and foreign key relationship, insert, update, and delete data in tables? Thanks, The db_ddladmin, db_datareader and db_datawriter roles should be sufficient.  SignatureTom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS SQL Server MVP Toronto, ON Canada https://mvp.support.microsoft.com/profile/Tom.Moreau I have several SQL Server 2005 databases on my server. What SQL Server 2005 security role has the least priviledges to complete the following capabilities? Able to create tables, triggers, create primary and foreign key relationship, insert, update, and delete data in tables? Thanks, |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.