Re: Least role permission
- From: "Russell Fields" <russellfields@xxxxxxxxxx>
- Date: Fri, 2 May 2008 15:11:12 -0400
zz12,
The Books Online are pretty good about answering this kind of question. Cut
and Paste from the SS2000 BOL:
TRUNCATE TABLE
Permissions
TRUNCATE TABLE permissions default to the table owner, members of the
sysadmin fixed server role, and the db_owner and db_ddladmin fixed database
roles, and are not transferable.
BULK INSERT
Permissions
Only members of the sysadmin and bulkadmin fixed server roles can execute
BULK INSERT.
Therefore, for Truncate Table, db_ddladmin is the least rights needed. For
Bulk Insert, the server level role bulkadmin is the least server rights and
I believe that the login must also have INSERT rights to the target table.
And this is all changed in SQL Server 2005.
RLF
"zz12" <IDontLikeSpam@xxxxxxxxxxx> wrote in message
news:eMK9oOIrIHA.1316@xxxxxxxxxxxxxxxxxxxxxxx
What would be the least db role permission to issue a user TRUNCATE TABLE
and INSERT BULK on a table in SQL2000?
.
- Follow-Ups:
- Re: Least role permission
- From: zz12
- Re: Least role permission
- References:
- Least role permission
- From: zz12
- Least role permission
- Prev by Date: Least role permission
- Next by Date: Network Service account authenticate itself as [NT Authority\Network Service]
- Previous by thread: Least role permission
- Next by thread: Re: Least role permission
- Index(es):
Relevant Pages
|