OraFAQ Forum: Server Administration » IS it possible-->Grant DROP Table to <username>/<rolename>

Home » RDBMS Server » Server Administration » IS it possible-->Grant DROP Table to <username>/<rolename>

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

IS it possible-->Grant DROP Table to <username>/<rolename> [message #199973]

Fri, 27 October 2006 04:25

tayalarun
Messages: 20
Registered: December 2005

Junior Member

Can I give (9i/10g - DB):

Grant DROP Table to <username>/<rolename>;

I don't wan't to give
Grant DROP any Table to <username>/<rolename>;

Giving "any" will give the privledge to drop any table.

Regards
Arun Tayal

Report message to a moderator

Re: IS it possible-->Grant DROP Table to <username>/<rolename> [message #202900 is a reply to message #199973]

Mon, 13 November 2006 04:20

vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad

Senior Member

There is no way to give DDL access on current schema to other users without using the "any" clause .. there is other way of acheiving this ..

create a procedure which will take parameter as tablename and will drop that table internally , then grant the execute privs on that procedure to the intended audience ..

Hope that helps
-Sai Jeedigunta
http://vasujeedigunta.blogspot.com

Report message to a moderator

Previous Topic:	Oracle job problem while bringing online - Oracle 9.2.0.6.0
Next Topic:	configure database server for only run report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 06:29:25 CDT 2024