PL/SQL API jcs.setuser
Summary
Override the requestor for whom jobs are to be submitted.
After jcs.setuser is called, authorization is not validated until you call jcs.setpassword or jcs.use_known_password or are identified externally.
This procedure should only be used in very specific instances where other users need to be IMPERSONATED. Under no circumstances should you call this by default! The result would be that you inadvertently submit jobs as different users with different privileges.
Using jcs.setuser and jcs.setpassword
...
jcs.setuser('MIKE');
jcs.setpassword('SANTACLAUS');
jcs.submit('WISHLIST');
commit;
...
Privileges
Calling jcs.setuser for externally identified users is only allowed if the real user has the ORACLE privilege SET_ANY_USER.
Specification
procedure setuser(username in varchar2)
Parameters
- username - the ORACLE username to set
Transaction keyword
The transaction keyword defines how and/or when the changes are committed to the database. A definition of the various transaction keywords can be found on the jcs package summary page.
none
See Also
plsqlTopic
onsiteTopic