A reader, January 11, 2017 - 10:32 am UTC
Hi Connor,
Thanks for the information.
Thanks,
How about a PROFILE like this
Rajeshwaran Jeyabal, January 11, 2017 - 2:31 pm UTC
rajesh@ORA12C> create profile temp_profile limit
2 sessions_per_user 2;
Profile created.
rajesh@ORA12C> alter user demo profile temp_profile;
User altered.
rajesh@ORA12C> conn demo/demo@ora12c
Connected.
demo@ORA12C>
with a second sql*plus connect to "demo" like this.
C:\Users\179818>sqlplus demo/demo@ora12c
SQL*Plus: Release 12.1.0.2.0 Production on Wed Jan 11 19:53:14 2017
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Last Successful login time: Wed Jan 11 2017 19:53:03 +05:30
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
demo@ORA12C>
with a third sql*plus connect to "demo" error ed like this.
C:\Users\179818>sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Wed Jan 11 19:53:20 2017
Copyright (c) 1982, 2014, Oracle. All rights reserved.
idle> conn demo/demo@ora12c
ERROR:
ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit
idle>
January 12, 2017 - 1:23 am UTC
(I think) the questioner wanted to restrict only people using TOAD, not sessions in general.