+ Reply to Thread
Results 1 to 4 of 4

Hybrid View

  1. 03-12-2002 01:38 AM #1
    anandharaj
    anandharaj is offline Member
    Join Date
    Feb 2001
    Location
    Atlanta, USA
    Posts
    131
    Dear Gurus,

    I wanted to know about "
    How to restrict multiple users, login as same login name in Oracle Applications".

    Could someone thro some light on this.

    TIA

    Anandharaj
    a_anandharaj@yahoo.com
    Reply With Quote Reply With Quote
  2. 03-12-2002 02:09 AM #2
    dbafreak
    dbafreak is offline Member
    Join Date
    Mar 2002
    Posts
    171
    There are definitely many ways of implementing this. Immediately that comes to my mind is the following:

    At the beginning of the login (say from an application) check for the USERNAME from v$session view. If the USERNAME exists, prompt a message and stop the USER. Hope it helps.
    Reply With Quote Reply With Quote
  3. 03-12-2002 02:20 AM #3
    SANJAY_G's Avatar
    SANJAY_G
    SANJAY_G is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    You can create a profile and specify how many concurrent session the user can have in SESSIONS_PER_USER. Assign this profile to the user.

    Sanjay
    Reply With Quote Reply With Quote
  4. 03-12-2002 05:28 AM #4
    anandharaj
    anandharaj is offline Member
    Join Date
    Feb 2001
    Location
    Atlanta, USA
    Posts
    131
    Dear Sanjay and dbafreak

    Thank you very much for your prompt replies.

    Is there any option to restrict the user thro' front-end. I mean SYSADMIN of Oracle Applications 11.0.3 or 11i ?



    Anandharaj
    a_anandharaj@yahoo.com
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules

 Click Here to Expand Forum to Full Width