Re: How can I limit # of CONCUR users with same uid/pwd?

   Read up on PROFILES in your documentation. You will find what you are looking for. Don't forget to set init.ora parameter resource_limit=TRUE.

• Doug

Eddie Hernandez (ejuan01_at_solix.fiu.edu) writes:
> I would like to limit the number of session created using the same
> userid/password (Except for the SYSTEM login for admin purposes.).
> In other words lets say my UID=eddie and PWD=hello,
> then only one eddie/hello can be logged into ORACLE at a time. Any other
> logins using the same UID/PWD would generate an error.
>
> I did set the LICENSE_MAX_SESSIONS but this only limits the number of
> different UID/PWD sessions. I was able to login as myself more than the
> LICENSE_MAX_SESSIONS value permits. I also do not want to mess with
> PROCESSES since this would limit my connections using Database tools as
> SYSTEM.
>
> Any help would be appreciated, thanks,
>
>
> ****************************************************************************
> Eddie Hernandez North Broward Hospital District
> Programmer/Oracle DBA 1608 SE 3rd Avenue
> hernb0_at_nbhd.org Ft. Lauderdale, FL 33316
> ***************************************************************************

--
   - Doug Harris
     IS Project Leader, Prices Division,
     Statistics Canada.        ## WHERE ALL_OPINIONS.OWNER = USER ##