OraFAQ Forum: Server Administration » Granting Truncate priviledges to Non table owner

Home » RDBMS Server » Server Administration » Granting Truncate priviledges to Non table owner

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Granting Truncate priviledges to Non table owner [message #54856]

Tue, 10 December 2002 05:25

Paul
Messages: 164
Registered: April 1999

Senior Member

I have user A and user B.
User B wishes to truncate a table owned by user A.
User A has granted all permissions to user B but still
User B is met with 'Insufficient priviedges' when attempting to truncate table.
Can someone specify exactly what i should type within sql plus to allow truncation on my table to another user.
Here is snapshot from my sql attempts -

SQL>grant drop on any table to intern;
grant drop on any table to intern
*
ERROR at line 1:
ORA-00990: missing or invalid privilege

but just get an error message when i also try quoted strinsg etc. All help very much appreciatted
Many Thanks
Paul.

Report message to a moderator

Re: Granting Truncate priviledges to Non table owner [message #54857 is a reply to message #54856]

Tue, 10 December 2002 06:48

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

correct syntax would be

sql>grant drop any table to intern;

but this would be a pain.(becuase the table itself is dropped, if the user ACCIDENTLY DROPS THE TABLE????).

Report message to a moderator

Previous Topic:	How to check if a user has ever been used.
Next Topic:	OCP MCSE CCNA CCNP JAVA -- Real Exam Questions

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 05:40:23 CDT 2024