grant truncate table permission - how?

From: Ron (anonymous_at_discussions.microsoft.com)
Date: 04/11/05 

Date: Mon, 11 Apr 2005 13:53:39 -0700

User1 has permission to run an sp (on sqlServer2k). The
sp truncates a table and then does other stuff. I get the
permission denied message for user1 to perform this
operation. I tried

Grant Truncate Table to User1

in query analyzer, but get the message

Privilege TRUNCATE TABLE may not be granted or revoked.

How do I give user1 permission to trucate tables in DB1?

Thanks,
Ron

Relevant Pages

  • Re: grant truncate table permission - how?
    ... A user with db_ddladmin role can issue any DDL command inside the database ... We can not revoke the permission for a specific ... He can Truncate the tables only on that particular database for which he got ... >I added user1 to ddladmin. ...
    (microsoft.public.sqlserver.security)
  • grant truncate table permission - how?
    ... I added user1 to ddladmin. ... possible to restrict what tables user1 can truncate? ... >permission denied message for user1 to perform this ...
    (microsoft.public.sqlserver.security)
  • Re: destroy table vs truncated
    ... Here's the table and it's very basic so I think truncate is the way to ... Alter table totwidth: 13 ... Permission 2: ... define permit retrieve on tmp_repo_rev to all ...
    (comp.databases.ingres)
  • Send As for DL not working
    ... I've given user1 Full Control over the ... I can't give Send On Behalf Of permission, because jobs ... tab does not have that control. ...
    (microsoft.public.exchange2000.admin)
  • Re: Permissions Inherited Despite Being Set Otherwise
    ... When I try to check the permission on the second document, ... we remove all the groups but leave Group1 full ... (Group1 has full control permission on the Document Library) ... We add user1 Design permission to document1. ...
    (microsoft.public.sharepoint.windowsservices)