4 months ago

How to Connect and Login as an Oracle User

Posted 4 months ago by johnw65

I'm new to Laravel, and is currently using Laravel 7.

Immediately after a successful user login, how can I immediately connect/reconnect as an actual Oracle User rather than as a web application user then execute DBMS_Session.Set_Role('ALL') which will grant the current user all roles.

It's a requirement and also want to be able to keep an audit trail on each Oracle users until the user logs out. The audit must be performed at the database level. Thanks in advance.

Please sign in or create an account to participate in this conversation.