Re: TRUNCATE TABLE permissions

From: AnthonyThomas (Anthony.Thomas_at_CommerceBank.com)
Date: 11/11/04 

Date: Thu, 11 Nov 2004 17:05:21 -0600

No, there is no way in 2000; however, the security is more granular in 2005.

The only other way would be to do the activity as a job or DTS under the
permissions of another user who did have those rights. At least this way,
it is coded and not ad hoc.

Sincerely,

Anthony Thomas 

-- 
"CC&JM" <CCJM@discussions.microsoft.com> wrote in message
news:79C101DD-2F3A-45AC-86E1-C466F01A30AE@microsoft.com...
> Hello,
>
> 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?
> BOL tells thats no possible but may be you know any trick.
>
> Thanks and best regards
>
>
>

Relevant Pages

  • 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: **different place for creating a new table**
    ... Only objects created by members of the sysadmin fixed server role (or by the ... dbo user) belong to dbo. ...
    (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)
  • 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.security)
  • Re: Triggers on Insert, Delete
    ... I guess it's the problem with permissions. ... the db_owner fixed database role in the master database ... and members of the sysadmin fixed server role, ...
    (microsoft.public.sqlserver.server)
Loading