Re: Deny Truncate

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 09/29/04


Date: Wed, 29 Sep 2004 14:58:55 -0600

Not directly. You need to manage this via roles and/or object
ownership. Table owners, sysadmin, db_owner and db_ddladmin can
truncate tables.

-Sue
 
On Wed, 29 Sep 2004 12:59:59 -0700, "Paul"
<anonymous@discussions.microsoft.com> wrote:

>Is there a way to Deny Truncate on tables?



Relevant Pages

  • Re: GNU Public Licences Revisited (again)
    ... help you comment more intelligently on joint ownership vs. ... German and English joint ownership laws as applied to copyrights ... ours or in a communist-oid legal system. ... to have the joint owners try to reach agreement without seeking a legal ...
    (comp.programming)
  • Re: JOBS
    ... Ownership is checked in the sp_help_job that calls ... ownership, sysadmin check, you should get an error that the ... can get the Unknown for execution status if it's a ... job and make sure it refers to the correct local server ...
    (microsoft.public.sqlserver.security)
  • Re: Specifying record source in a form control based on selection
    ... Having multiple instances of the Unit to specify Ownership shares would ... OwnerID (primary key) ... Owners, by the Units table. ... there would be a record in the Partnership table ...
    (microsoft.public.access.formscoding)
  • Re: The Reality on Junior
    ... owners and drivers are who I follow. ... It appears that this is a Cat fight with Dale as ... she ended up getting 0% ownership for him. ...
    (rec.autos.sport.nascar)
  • Re: New CEO?
    ... equity where 'fund managers' make decisions. ... The notion ownership is almost ... I believe that owners of a company "should" care about what the ...
    (borland.public.delphi.non-technical)