truncate table

From: DeeJay Puar (deejaypuar_at_yahoo.com)
Date: 06/22/04 

Date: Tue, 22 Jun 2004 08:32:38 -0700

Hi,

Truncate table permissions are NOT transferable. Only
table owners and dbo's have this permission.

Perhaps, you could change table ownership.

TIA
DeeJay
>-----Original Message-----
>Can you explicity grant access to truncate a specific
>table to a login id without giving dbo permissions on a
>database.
>
>I have a job that first truncates a table and then runs a
>dts job to import into that table. I do not want to give
>the account that runs the job any additional permissions
>than necessary.
>
>thanks..
>
>
>.
>

Relevant Pages

  • Re: Truncate Table vs. Delete From
    ... TRUNCATE TABLE permissions default to the table owner, ... of the sysadmin fixed server role, ...
    (microsoft.public.sqlserver.security)
  • Permissions for executing a stored procedure
    ... Truncate table permissions only default to table owner, ... So, eventhough, you have granted execute permissions to ... Instead using TRUNCATE TABLE, you could use DELETE FROM, ... >We have a stored procedure that has code in it to ...
    (microsoft.public.sqlserver.security)
  • Re: With in a SP Truncate dbo.table table-name permissions..
    ... TRUNCATE TABLE permissions default to the table owner, ... According to sql server ... If a user who creates a stored procedure does ...
    (microsoft.public.sqlserver.security)
  • Re: Truncate Table vs. Delete From
    ... permissions (SELECT, INSERT, UPDATE, DELETE, EXECUTE and REFERENCES). ... TRUNCATE TABLE) are different. ...
    (microsoft.public.sqlserver.security)
  • Truncate Table vs. Delete From
    ... If you want to delete all the rows in a table, TRUNCATE ... Delete permissions default to members of the sysadmin ... permissions on a Stored Procedure overrides any ... Truncate Table command. ...
    (microsoft.public.sqlserver.security)