Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2012

    Red face Unanswered: Problem in changing user privileges

    Hi I'm getting the following error when trying to grant privileges for user:

    [IBM][CLI Driver][DB2/NT64] SQL0555N An authorization ID cannot
    revoke a privilege from itself. SQLSTATE=42502


    An authorization ID attempted to execute a REVOKE statement where the
    authorization ID itself appears as one of the entries in the
    authorization ID list from which privileges are to be revoked.

    The statement cannot be processed.

    User response:

    Remove the authorization ID from the list.

    sqlcode: -555

    sqlstate: 42502

    please help me in resolving the issue.

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 5
    The message seems rather clear in what it states is the issue. You cannot revoke a privilege from yourself. You will need to do it from a higher authority.


Posting Permissions

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