RE: truncate a table via a stored procedure

From: Kevin McDonnell [MSFT] (kevmc_at_online.microsoft.com)
Date: 12/18/03 

Date: Wed, 17 Dec 2003 23:36:32 GMT

>From SQL Books Online;

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

Thanks,

Kevin McDonnell
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.

Relevant Pages

  • Re: TRUNCATE TABLE permissions
    ... permissions of another user who did have those rights. ... > Is there any possibility to give the TRUNCATE TABLE permission and avoid> that the user that will execute this statement be table owner, members of the> sysadmin fixed server role, db_owner or member of the db_ddladmin fixed> database roles? ...
    (microsoft.public.sqlserver.server)
  • 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: Triggers on Insert, Delete
    ... I guess it's the problem with permissions. ... the db_owner fixed database role in the master database ... and members of the sysadmin fixed server role, ...
    (microsoft.public.sqlserver.server)
  • Re: Help with sp_start_job and xp_sqlagent_proxy_account
    ... >>>user is not a member of the sysadmin fixed server role and the job has ... >>>domain administrators account. ...
    (microsoft.public.sqlserver.security)