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
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
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
can you give example davey :cool:
thanks
i could, but that would be doing peoples work for them. I;ll leave that as an exercise to the reader
you are smart dear :D can i do it using a function too :)