Re: deny truncate?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Jacco Schalkwijk (jacco.please.reply_at_to.newsgroups.mvps.org.invalid)
Date: 10/13/04 

Date: Wed, 13 Oct 2004 14:27:30 +0100

Only members of the sysadmin server role and the db_owner and db_ddladmin
database roles and the table owner have permissions to Truncate the table. 

-- 
Jacco Schalkwijk
SQL Server MVP
"Bonj" <Bonj@discussions.microsoft.com> wrote in message 
news:86930C7A-AC66-4E96-AB9C-487200CD223D@microsoft.com...
> What if I want to give users Query Analyzer-style access to my data, but
> don't want them to delete it?
> I can do
> deny delete on dbo.mytable to public
>
> which is great... assuming they don't know how to do 'truncate table'.
>
> uh?
>
> is there any way I can prevent users from truncating a table by 
> permissions?

Relevant Pages

  • Re: deny truncate?
    ... Only members of the sysadmin server role and the db_owner and db_ddladmin ... database roles and the table owner have permissions to Truncate the table. ...
    (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)
  • 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)