Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2002
    Posts
    16

    Unanswered: authorization id

    I got the sql0567N message "<authorization-ID" is not a valid authorization ID. How to correct the invalid authorization ID? Thanks!

  2. #2
    Join Date
    Sep 2002
    Posts
    456

    Re: authorization id

    Make sure you using the valid user to connect to database!!!

    dollar

    Originally posted by alex_db
    I got the sql0567N message "<authorization-ID" is not a valid authorization ID. How to correct the invalid authorization ID? Thanks!

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

    Re: authorization id

    [mhpi01][/qa/nmr/users/mhpi01]$db2 "? sql0567n"

    SQL0567N "<authorization-ID>" is not a valid authorization ID.

    Explanation: The authorization ID specified by
    "<authorization-ID>" is not valid for one of the following
    reasons:

    o It begins with "SYS", "sys", "IBM", "ibm", "SQL", or "sql".

    o It contains characters other than a through z, A through Z, 0
    through 9, and the three special characters (#,@.$).

    o It is delimited and contains lower case letters.

    o It is GUESTS, ADMINS, USERS, or LOCAL.

    o It is PUBLIC preceded by the keyword USER or GROUP in a GRANT
    or REVOKE statement.



    The statement cannot be processed.

    User Response: Correct the invalid authorization ID.

    sqlcode: -567

    sqlstate: 42602

Posting Permissions

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