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
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
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
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
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:
  


Current Time: Sun Dec 04 06:30:32 CST 2016

Total time taken to generate the page: 0.06945 seconds