Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > Oracle
Oracle General Oracle database discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old November 11th, 2003, 02:23 AM
Registered User
Join Date: Nov 2003
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default restrict logon to single session

I want to create a user who can only have one logon session. The rest of the database users should be able to have multiple logons.
I was thinking of using a 'onlogon' trigger but haven't got it working yet.
Any help appreciated!

Anthony (Tony) Hunter
Spatial Databases & GIS Applications
Old November 29th, 2003, 05:18 AM
Registered User
Join Date: Nov 2003
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts


I can use following code:

create profile one_session limit session_per_user 1;
alter user SCOTT profile one_session;
alter system set resource_limit=true;

User your user name instead "SCOTT"

Brgs, Sasha.

Old December 3rd, 2003, 03:54 PM
sal sal is offline
Friend of Wrox
Join Date: Oct 2003
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts

Anyway, is there a table in Oracle that keeps the current login names? is there is (should be) you can do your trigger on that table (if oracle will let you mod a sys table).

Old March 11th, 2004, 03:11 PM
aas aas is offline
Authorized User
Join Date: Mar 2004
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to aas

Or you can create database event trigger on logon and check user then.

Similar Threads
Thread Thread Starter Forum Replies Last Post
ASP.Net Single Single-on with Oracle Application S guhanath Oracle 0 October 6th, 2004 05:05 AM
Restrict elements guozhang XML 0 April 28th, 2004 02:26 PM
how to restrict strings with particular characters srini XSLT 6 November 28th, 2003 07:03 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.