Sean's Blog
A place where I record bits and pieces :)
Tuesday, July 14, 2020
Oracle Connect as another user
CONNECT SYSTEM/&system_password@&target_database;
ALTER USER &local_schema GRANT CONNECT THROUGH SYSTEM;
DISCONNECT;
CONNECT SYSTEM[&local_schema]/&system_password@&target_database;
ALTER USER &local_schema REVOKE CONNECT THROUGH SYSTEM;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment