Results 1 to 7 of 7
  1. #1
    Join Date
    Nov 2003
    Posts
    7

    Unanswered: SESSIONS_PER_USER in ORACLE

    Hi,

    I want to restrict the users for concurrent usage. i.e., The same user should not login until otherwise he logged out.

    I have tried with the following method, but it is not working.

    Can any one help me out.

    Thanks in advance

    Regards,

    DKN

  2. #2
    Join Date
    Nov 2003
    Posts
    7

    Re: SESSIONS_PER_USER in ORACLE

    Originally posted by deekkanb
    Hi,

    I want to restrict the users for concurrent usage. i.e., The same user should not login until otherwise he logged out.

    I have tried with the following method, but it is not working.

    Can any one help me out.

    Thanks in advance

    Regards,

    DKN

    sorry, i forgot to include the code.

    CREATE PROFILE testprofile LIMIT SESSIONS_PER_USER 1

    CREATE USER testuser IDENTIFIED BY test
    PROFILE testprofile

    Regards,
    DKN

  3. #3
    Join Date
    Jan 2004
    Posts
    370
    You need to set resource_limit parameter to true

  4. #4
    Join Date
    Nov 2003
    Posts
    7
    Originally posted by SkyWriter
    You need to set resource_limit parameter to true

    Can you tell me how to set the RESOURCE_LIMIT to TRUE?

    Regards,
    DKN

  5. #5
    Join Date
    Jan 2004
    Posts
    370
    In Oracle 9
    alter system set resource_limit=true;

    Pre-Oracle9 you need to set it in the init.ora

  6. #6
    Join Date
    Nov 2003
    Posts
    7

    Smile Thanks !

    Thanks a lot !

    It is working.

    Regards,
    DKN

  7. #7
    Join Date
    Nov 2003
    Posts
    7

    Equivalent in SQL server

    Thanks, I got it in Oracle.

    How we can do this in SQL server?

    Thanks in advance

    Regards,
    DKN

Posting Permissions

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