Re: Instead of DBO

Rob (Rob@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
We have a user who needs to do the following:
1) Truncate table
2) Create temp table

Anyone can create temp table. When you say TRUNCATE TABLE, is that on
temp tables or regular tables?

Instead of granting this user DBO on the DB, what explicit permissions
and/or role assignments can he be added to?

To do TRUNCATE TABLE on a permanent table, you need ALTER permission on
that table, or membership in the db_ddladmin fixed database role.


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: Log Invalidated after truncate table
    ... > just enough information in the log file to rollback if the transaction ... TRUNCATE TABLE logs the extent deallocations, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Trucate Command
    ... Insert into temp select * from real_table where date_col between ... Truncate the original table -- This step will ... you can not do any kind of recovery using truncate table command. ... into syntax will look as follows. ...
    (microsoft.public.sqlserver.mseq)
  • Re: user defined Role - HELP
    ... does not have permission on tblUReport" am thoroughly stumped on why it ... This is because ownership chaining does not apply to TRUNCATE TABLE. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.security)
  • Re: Delete without log ??
    ... and after a lot of test I use the TRUNCATE (with ... temp tables to keep the data that I need) ... > (Create your own groups, Forum, FAQ's and a ton more) ...
    (microsoft.public.sqlserver.server)
  • Re: Truncating a cell value AFTER the decimal place
    ... If you are always removing the last digit of the value: ... Sub truncateLastDigit() ... temp = ActiveCell.Value ... My understanding of the truncate function is that it will truncate the ...
    (microsoft.public.excel.programming)