Re: deny truncate?

From: Keith Kratochvil (sqlguy.back2u_at_comcast.net)
Date: 10/13/04 

Date: Wed, 13 Oct 2004 09:23:16 -0500

>From 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.

The bottom line: Manage security properly and the users will not have
rights to do anything that you do not want them to. 

-- 
Keith
"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: Truncate Table vs. Delete From
    ... TRUNCATE TABLE permissions default to the table owner, ... of the sysadmin fixed server role, ...
    (microsoft.public.sqlserver.security)
  • 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: truncate a table via a stored procedure
    ... 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: Stored procedures + 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." ... I have a stored procedure 'DoTurnover' which should do a 'truncate table' on two specific tables; how can I achieve to give this procedure the proper permission? ...
    (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.programming)