Revoking Object Privileges from OWNER itself
AskTom Fan :), December 20, 2005 - 8:29 am UTC
hi tom
how can we revoke the select/insert..etc. privileges on a table from the USER who is also the OWNER of that table?
December 20, 2005 - 9:44 am UTC
you cannot, doesn't "make sense"
the correct approach - this "owner" doesn't actually OWN the objects - someone else does.
Or this "owner" doesn't have CREATE SESSION - so they cannot log in.
how to give rights to the different users
MUJAHID, May 06, 2007 - 1:42 pm UTC
TOM I HAVE CREATED THE MENU IN ORACLE 6I AND DEVELOPED SOME FORMS AND I WANT THE GIVE RIGHTS TO THE USER HOW CAN I GIVE THE RIGHT FOR ACCESSING THE MENUS...