Re: Least role permission

Thanks for clearing this RLF. Much appreciated.


"Russell Fields" <russellfields@xxxxxxxxxx> wrote in message
news:uhelKhIrIHA.1316@xxxxxxxxxxxxxxxxxxxxxxx
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
    ... TRUNCATE TABLE permissions default to the table owner, ... sysadmin fixed server role, and the db_owner and db_ddladmin fixed database ... 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)