Re: Prevent multiple login
From: AMARENDRA B NETTEM <nettama_at_charlie.cns.iit.edu>
Date: 1998/01/14
Message-ID: <34BCE64B.1546_at_charlie.cns.iit.edu>#1/1
Date: 1998/01/14
Message-ID: <34BCE64B.1546_at_charlie.cns.iit.edu>#1/1
Tapan Das wrote:
>
> 1. What are the methods of preventing multiple logins by one user in Oracle?
>
> 2. How to prevent multiple login by one user from a front-end PB
> application?
>
> Thanks in advance,
>
> Tapan Das
> tapand_at_erols.com
Hi,
To prevent multiple logins for one user create one more profile
other than DEFAULT profile and change the
RESOURCE NAME (SESSIONS_PER_USER =1).
(look in DBA_PROFILES TABLE)
Hope this helps
AMARENDRA
-- ****************************************************************************** AMARENDRA B NETTEM 5039 N E River Road, Apt. 1A Oracle Certified DBA (OCP) NORRIDGE, IL 60656 Whittman-Hart Inc., 311 South Wacker Drive, Suite 3500 Chicago, IL 60606. Ph.No. (708) 583 9870 (H) (312) 913 6758 (W) E-mail:nettama_at_charlie.cns.iit.edu, anettem_at_whittman-hart.com Homepage: http://www.iit.edu/~nettama **************************************************************************** Opinions are mine and do not necessarily reflect those of Whittman-hart Inc.Received on Wed Jan 14 1998 - 00:00:00 CET