Monday, September 21, 2009

Using DBMS_SYS_SQL to Execute Statements as Another User | Pythian Group Blog

Using DBMS_SYS_SQL to Execute Statements as Another User | Pythian Group Blog: "Sometimes you need to execute SQL (or PL/SQL) as some other user. Say you need to remove a job residing in some other user’s schema. Or you need to create a database link in a different schema. You can’t do things like these without becoming the other user. If you don’t know the other user’s password then you basically have two choices"