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: Web server name
Next Topic: ProfileCreatedDate
Goto Forum:

Current Time: Sat Aug 19 21:24:07 CDT 2017

Total time taken to generate the page: 0.21294 seconds