Re: Create PK / FK Tables Security
- From: "Tom Moreau" <tom@xxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 25 Jan 2008 08:16:01 -0500
The db_ddladmin, db_datareader and db_datawriter roles should be sufficient.
--
Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Dean P." <Dean P.@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B7A53B80-61E5-476B-9F62-295803E3A676@xxxxxxxxxxxxxxxx
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,
.
- Prev by Date: Re: how to give create table permissions only
- Next by Date: Can't login to SQL Server
- Previous by thread: Re: SQL Stored procedure access?
- Next by thread: Can't login to SQL Server
- Index(es):
Relevant Pages
|
