Results 1 to 6 of 6

Thread: Authorities

  1. #1
    Join Date
    Sep 2003
    Posts
    84

    Unhappy Unanswered: Authorities

    Hello

    I am using DB2 V8.1 ( no fixpak) on AIX 5.1. So far, I have been using the instance owner for the various operations on the databases belonging to that instance.

    However, when I grant ( by connecting to the db as instance owner and then issuing the command GRANT DBADM on DATABASE to user YYY) DBADM authority to an OS user and then try connecting to the db using this user it returns me SQL30082N with reason code 24 ( Invalid userid/password). However, I am able to logon to the OS using the same user and password.

    I am trying to connect to the db from the server itself.

    Any ideas where the problem is ?

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Authorities

    What sort of authentication is it ?

    CLIENT/SERVER ?

    Cheers
    Sathyaram


    Originally posted by Dipanjan
    Hello

    I am using DB2 V8.1 ( no fixpak) on AIX 5.1. So far, I have been using the instance owner for the various operations on the databases belonging to that instance.

    However, when I grant ( by connecting to the db as instance owner and then issuing the command GRANT DBADM on DATABASE to user YYY) DBADM authority to an OS user and then try connecting to the db using this user it returns me SQL30082N with reason code 24 ( Invalid userid/password). However, I am able to logon to the OS using the same user and password.

    I am trying to connect to the db from the server itself.

    Any ideas where the problem is ?
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Sep 2003
    Posts
    84

    Re: Authorities

    Following are the dbm config parameters :-


    Database manager authentication (AUTHENTICATION) = SERVER
    Cataloging allowed without authority (CATALOG_NOAUTH) = NO
    Trust all clients (TRUST_ALLCLNTS) = YES
    Trusted client authentication (TRUST_CLNTAUTH) = CLIENT
    Use SNA authentication (USE_SNA_AUTH) = NO
    Bypass federated authentication (FED_NOAUTH) = NO

  4. #4
    Join Date
    Sep 2003
    Posts
    84
    I have got it to work , but this baffles me.

    Previously I was logging on as the new user onto the OS and then issuing the following command :-

    CONNECT to DB user AAA using BBB.
    This was returning me the error msg.

    However, now when I only say CONNECT to DB it connects.

    And when I connect to the db as the instance owner using CONNECT to DB user instanceowner using password it works.

    Can someone please explain to me this scenario ?

  5. #5
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    When you say,

    connect to db

    db2 does not go to the OS and ask for password authentication
    whereas, for
    connect to d user user1 using passw

    db2 asks the os to verify the uuid/password

    Since, your instance owner works with the uid/pwd, seems that the system is in shape ... Verfiy the properties of the 'problematic' user

    HTH

    Sathyaram



    Originally posted by Dipanjan
    I have got it to work , but this baffles me.

    Previously I was logging on as the new user onto the OS and then issuing the following command :-

    CONNECT to DB user AAA using BBB.
    This was returning me the error msg.

    However, now when I only say CONNECT to DB it connects.

    And when I connect to the db as the instance owner using CONNECT to DB user instanceowner using password it works.

    Can someone please explain to me this scenario ?
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  6. #6
    Join Date
    Sep 2003
    Posts
    84
    But the userid works while logging me on to the OS. What else can be wrong ?

Posting Permissions

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