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: SQLBulkCopy CLass - For Updates?
    ... SQLBulkCopy populate that, and then call a proc ... to update the actual table in the end (and perhaps truncate the work ... For one thing, a mass UPDATE produces far more overhead in the transaction log than a BULK INSERT, so it might not be acceptable compared to lots of "regular" UPDATE statements. ... If the updated values can be completely determined in the database, though, it's far more efficient to have the database do it, as you save network roundtrips. ...
    (microsoft.public.dotnet.languages.csharp)
  • 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: 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)