This content has been marked as final. Show 2 replies
Login as a user with ALTER ANY USER privileges, like sys.
Grant proxy login, say to yourself.
SQL> ALTER USER that_user GRANT CONNECT THROUGH user_me;
Now you can use proxy login and you do not need that user's passwrd
SQL> connect user_me[that_user]@mydatabase
When prompted enter your password.
You will be logged in as that_user.
You could also login as yourself with sufficient privileges.
SQL> CREATE TABLE that_user.new_table AS SELECT * FROM that_user.old_table;
SQL> ALTER TABLE that_user.old_table RENAME TO new_table;
You can do pretty much anything you want in another schema if you have sufficient privileges yourself. DBA role comes to mind, but be careful as it is all powerful.