I want to create a user who can only have one logon session. The rest of the database users should be able to have multiple logons.
I was thinking of using a 'onlogon' trigger but haven't got it working yet.
Any help appreciated!

Anthony (Tony) Hunter
Spatial Databases & GIS Applications

Hi

I can use following code:

create profile one_session limit session_per_user 1;
alter user SCOTT profile one_session;
alter system set resource_limit=true;

User your user name instead "SCOTT"

Brgs, Sasha.

Anyway, is there a table in Oracle that keeps the current login names? is there is (should be) you can do your trigger on that table (if oracle will let you mod a sys table).



Sal

Or you can create database event trigger on logon and check user then.