DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: IDLE TIME FOR THE USER - format

  1. #1
    Join Date
    Dec 2001
    Location
    SAN FRANCISCO, CA
    Posts
    306
    BOSS
    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
    --Pravin


    Eat , Drink & Enjoy life -

    pravin_kini@hotmail.com

  2. #2
    Join Date
    May 2000
    Posts
    50
    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