Home » RDBMS Server » Server Administration » IS it possible-->Grant DROP Table to <username>/<rolename>
IS it possible-->Grant DROP Table to <username>/<rolename> [message #199973] Fri, 27 October 2006 04:25 Go to next message
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.

Arun Tayal
Re: IS it possible-->Grant DROP Table to <username>/<rolename> [message #202900 is a reply to message #199973] Mon, 13 November 2006 04:20 Go to previous message
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
Previous Topic: Oracle job problem while bringing online - Oracle
Next Topic: configure database server for only run report
Goto Forum:

Current Time: Wed Oct 26 09:10:12 CDT 2016

Total time taken to generate the page: 0.05762 seconds