How can I limit the number of times a single user can connect to the database at any one time ?

2011-01-01

629

The Oracle (tm) Users' Co-Operative FAQ

How can I limit the number of times a single user can connect to the database at any one time ?

Author's name: Connor McDonald Author's Email: connor_mcdonald@yahoo.com	Date written: August 27, 2001 Oracle version(s): 7.3+
How can I limit the number of times a single user can connect to the database at any one time ?

SQL> create profile SESSION_LIMITER limit sessions_per_user nnn;
SQL> alter user USER1 profile SESSION_LIMITER;
SQL> alter system set resource_limit = true
(and change the init.ora file as well)

Voila!

How can I limit the number of times a single user can connect to the database at any one time ?

The Oracle (tm) Users' Co-Operative FAQ

How can I limit the number of times a single user can connect to the database at any one time ?

评论