IS it possible --> Grant DROP Table to <username>/<role anme>;

[tayalarun]

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

Grant DROP Table to /;

I don't wan't to give
Grant DROP any Table to /;

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


Regards
Arun Tayal

[davey23uk]

no, but you could create a stored prcoedure in your own schema which takes a tablename as a parameter, then you can give execute on that proc to whoever

[yxez]

can you give example davey
thanks

[davey23uk]

i could, but that would be doing peoples work for them. I;ll leave that as an exercise to the reader

[yxez]

you are smart dear can i do it using a function too