Re: Least role permission

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?




.

Relevant Pages

  • Re: Least role permission
    ... sysadmin fixed server role, and the db_owner and db_ddladmin fixed ... BULK INSERT ... Therefore, for Truncate Table, db_ddladmin is the least rights needed. ...
    (microsoft.public.sqlserver.security)
  • Re: Truncate Table vs. Delete From
    ... TRUNCATE TABLE permissions default to the table owner, ... of the sysadmin fixed server role, ...
    (microsoft.public.sqlserver.security)
  • Re: deny truncate?
    ... TRUNCATE TABLE permissions default to the table owner, ... sysadmin fixed server role, and the db_owner and db_ddladmin fixed database ...
    (microsoft.public.sqlserver.programming)
  • Re: deny truncate?
    ... TRUNCATE TABLE permissions default to the table owner, ... sysadmin fixed server role, and the db_owner and db_ddladmin fixed database ...
    (microsoft.public.sqlserver.security)
  • Re: ADO.net, asp.net & Bulk Copy
    ... Members of the bulkadmin role are allowed to execute the BULK INSERT ... So you need to add the user to the Fixed server role. ... >> HTH ... >> Elton Wang ...
    (microsoft.public.dotnet.framework.adonet)