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 ?

Back to index of questions


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!


Further reading: N/A


Back to top

Back to index of questions