Re: Permission to TRUNCATE table

Elmo <DoNoSpam_at_NoSpam.org> wrote:

>DJ wrote:
>> "Elmo" <DoNoSpam_at_NoSpam.org> wrote in message
>> news:bn45d8$19s6$1_at_f04n12.cac.psu.edu...
>>
>>>I have set up a ROLE and assigned permissions to INSERT, SELECT,
>>>DELETE, and UPDATE tables to that ROLE.
>>>
>>>I have a user with that ROLE.
>>>
>>>The user cannot TRUNCATE TABLE_NAME but can DELETE FROM TABLE_NAME.
>>>
>>>What permission/rights needs to be granted in order to TRUNCATE the
>>>table?
>>>
>>>Anyone with a clue? I'm fresh out.
>>>
>>
>>
>> is it through a procedure? could well need to explicitly grant truncate to
>> that user
>>
>>
>Nope. Just as simple as can be.

From the docs at
http://tahiti.oracle.com

'To truncate a table or cluster, the table or cluster must be in your schema or you must have DROP ANY TABLE system privilege. '

Hth,

----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Received on Wed Oct 22 2003 - 09:03:49 CDT