GRANT ALTER ANY TABLE TO UserName + Revoke Grant
586405Dec 3 2007 — edited Dec 3 2007Hi All,
I want to redefine my tables using DBMS_REDEFINITION package.
I had given the grants
GRANT EXECUTE ON DBMS_REDEFINITION TO USERNAME;
but, it also require the grants such as,
GRANT ALTER ANY TABLE TO USERNAME; and SELECT, CREATE, DROP and LOCK grants also.
Is there any other alternative then, giving such generous grants to particular user.
If we don't have any other option, can we revoke this grant from the user after redefinition is over.
How can we revoke this grants?