DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2001
    solaris 2.8 /oracle 8.1.7

    i have to create oracle user and also i have to give idle time to those users.

    Meaning that if they login to sql and when the work is done , but the sql session is still there in their desk top , so by specifying idle time it should disconnect.

    so the syntax will be
    create user < xxx>
    identified by < xxx>
    default tablespace
    temporary tablespace
    quota unlimited on < default tablespace>
    quota unlimited on
    idle time ? ( HOW WILL I SPECIFY THIS ) Can any body give me the format
    suppose if i haveto give idle time for 2 hours so should i write 120 there .

    second do i have to make any parameter change in init.ora for this.

    thanks in advance

    Eat , Drink & Enjoy life -


  2. #2
    Join Date
    May 2000
    Use Profiles. And then assign that profile to those users. And yes, you have to use 120. (in minutes).

Posting Permissions

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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.