|
|
||||||
|
#1
08-01-07, 04:02 PM
|
|
|
|
|
hi,
we have object-level user security. That user need permission for truncate one table. I can't set the user as sysadmin or DBO. any way that I could grant the user to have truncate that table? Thanks |
|
|
|
#2
08-01-07, 04:03 PM
|
|
|
|
|
DELETE ?
"mecn" <mecn2002> wrote in message news:1336 [..] |
|
#3
08-01-07, 04:08 PM
|
|
|
|
|
For some reason we could NOT use delete.
1. Identity id reset. 2. large table "Uri Dimant" <urid> wrote in message news:1100 [..] |
|
#4
08-02-07, 04:52 AM
|
|
|
|
|
#5
08-02-07, 07:32 AM
|
|
|
|
|
On Aug 2, 8:52 am, Pranil <Pra> wrote:
> "EXECUTE AS" ? > > [..] >> > "mecn" wrote: >> > > - Show quoted text - You need to have alter permission on the table to get the truncate permission. Thanks Shiju Samuel |
|
#6
08-02-07, 10:08 AM
|
|
|
|
|
If you are on 2005, you can grant CONTROL permissions.
|
|
|
| Similar Threads | |
| Grant rights to Truncate table to specific user 2000/2005 Hi For certain "work" tables only, I would like to grant truncate table ability. In SQL2005 I can do GRANT ALTER ON dbo.tbl#### TO myuser Is there one syntax will work... |
|
| grant (Alter table) permission on a single table in the database Product: Microsoft SQL server Enterprise Edition (2000) O/S: MS Windoes NT (5.2) Version: 8.00.760 ===================================================== Can we grant (Alter... |
|
| How do I GRANT TRUNCATE TABLE? It kept complaining about syntax error.. |
|
| grant truncate table permission - how? User1 has permission to run an sp (on sqlServer2k). The sp truncates a table and then does other stuff. I get the permission denied message for user1 to perform... |
|
| Permission to Truncate Table Hi all, I have this stored procedure that works with a big table. This is a work space table for several users: (They load records on this table, modify them and then... |
|
|
All times are GMT. The time now is 05:04 AM. | Privacy Policy
|
Grant permission to table for truncate table