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 ?

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