How do I grant this "Alter Any User" to a user? I can grant other privileges but not this one. Is this working at all?
Create user ABC identified by DFG;
Grant Alter Any User to ABC;
There is no such privilege ALTER ANY USER, check
select * from dba_sys_privs where privIlege like 'ALTER%USER';
DBA ALTER USER YES
You can grant alter user for the same purpose.
I have been asked with this question, and same here I don't think it exist. You suggestions are what exactly I thought, but would like to find out from the experts out here first. I might have limited knowledge.
Click Here to Expand Forum to Full Width