Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2004
    Posts
    190

    Unanswered: restrict connections to database

    What is the db2 7.1 equilavent to the Oracle command 'startup restrict' ? The restrict mode does not allow users to connect to a database if they don't have sufficient authority.

    Thanks

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    By default, connect privledge to a database is given to public when the database is created. So if you just revoke this authority (or any specific connect grants to id's you want to revoke), you shoud get what you want.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    It may be the quiesce database/instance command you want ...

    You should be atleast on V8.1 to have this feature

    Cheers
    Sathyaram



    Quote Originally Posted by redwolf
    What is the db2 7.1 equilavent to the Oracle command 'startup restrict' ? The restrict mode does not allow users to connect to a database if they don't have sufficient authority.

    Thanks
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    If you want to only allow sysadm authority to have access to a database, then the quiesce ccommand should work fine. If you want other specific users to be able to connect (but not everyone) then you can control it by revoking their connect privledge.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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