Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 339
  • Last Modified:

Oracle session

Hello All,

I need to load few values in oracle session whenever user connects, is there a way I can achieve in oracle

-D
0
dojjol
Asked:
dojjol
2 Solutions
 
sdstuberCommented:
use a on logon trigger

CREATE OR REPLACE TRIGGER trg_deny_remote_admins
    AFTER LOGON
    ON DATABASE

BEGIN  
       --- put your session queries here
END;
0
 
OP_ZaharinCommented:
- i would like to add further on using logon trigger as pointed by sdstuber.
- create a table consist of the session column and add new columns for the additional value you require to be added to the session detail. by using the logon trigger, you can insert the session details together  with the additional value. the steps and approach can be read further in the following link:

http://webcache.googleusercontent.com/search?q=cache:http://www.dba-oracle.com/art_builder_sec_audit.htm 
0
 
dojjolAuthor Commented:
Thanks and my apologies for late reply.

Can we create session level function, in place of trigger when we login we create a function specific to session.
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now