This discussion is archived
7 Replies Latest reply: Jan 17, 2013 5:46 AM by 846231 RSS

User Profile

846231 Newbie
Currently Being Moderated
Hi all,


I want to limit a user to login only 1 session in the database. I think I can do this with user profile? Right?



Thanks a lot
  • 1. Re: User Profile
    Niket Kumar Pro
    Currently Being Moderated
    yes,

    create new profile with SESSIONS_PER_USER as 1.
    change user profile to new profile.....

    Edited by: Niket Kumar on Jan 17, 2013 6:02 PM
  • 2. Re: User Profile
    846231 Newbie
    Currently Being Moderated
    graci :)
  • 3. Re: User Profile
    846231 Newbie
    Currently Being Moderated
    it did not work :( please help ....



    SQL> create profile user_profile2 limit SESSIONS_PER_USER 1;

    Profile created.


    SQL> alter user system profile user_profile2;

    User altered.

    SQL> show user
    USER is "SYSTEM"


    But when i login using another3 separate windows 3 times I can still login as system.
  • 4. Re: User Profile
    846231 Newbie
    Currently Being Moderated
    helpp
  • 5. Re: User Profile
    Niket Kumar Pro
    Currently Being Moderated
    No of Concurrent Sessions Per User  Mismatch with profile settings

    you need to do:

    alter system set resource_limit=true;
    SQL> conn / as sysdba
    Connected.
    SQL>
    SQL>
    SQL>
    SQL> alter system set resource_limit=true;
    
    System altered.
    
    
    
    
    
    
    SQL>  conn system/oracle@xe
    ERROR:
    ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit
    
    
    Warning: You are no longer connected to ORACLE.
    SQL>
    now its working

    Edited by: Niket Kumar on Jan 17, 2013 6:34 PM

    Edited by: Niket Kumar on Jan 17, 2013 6:35 PM
  • 6. Re: User Profile
    EdStevens Guru
    Currently Being Moderated
    KinsaKaUy? wrote:
    helpp
    Puh-lease.

    How long have you been on this board? How many times have you read this:

    ====================
    Patience, Grasshopper

    This forum is not a chat line, and it is not paid support.

    Everyone here has a job for which they are paid, and this forum is not it.

    No one is responsible for monitoring it and giving a quick response.

    Furthermore, it is a global forum. The person with the information you seek may very well live 20 time zones away from you and was going to bed just as you posted. He will not even see your post for several more hours.

    Your original post went up in the middle of the night for half the world.

    *No one with the information you seek is deliberately withholding it until you sound sufficiently desperate.*

    ===========================================
  • 7. Re: User Profile
    846231 Newbie
    Currently Being Moderated
    Thanks Ed for the reminder, It is noted.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points