sql - Change user during session through a query -
I am currently logged in as an administrator on an Oracle database and I can change my session user with a session Want to Is this possible?
Unfortunately, with ALTER SESSION SET CURRENT_SCHEMA = Schema Name & gt;
(as suggested in the comments) does not switch the user too, it allows you to avoid specifying a schema in your SQL statements during the session. In Oracle Database, users and schemas are different, but each user has a schema.
However you can apply your needs.
SET ROLE
statement during your session.
Comments
Post a Comment