Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Provided Answers: 1

    Unanswered: DB2 does not check is user exists when executing grant

    when executing grant command on db2 v9.5 database does not check if that user exists on system. For example if user is not set at time of grant and then sysadmin creates new user with the same userid then that user can get unattented privilages.

    Is there any way to tell DB2 to check if user exists when grant is executed?

  2. #2
    Join Date
    Aug 2001
    You are right in your observation. This has been the case always. AFAIK, you cannot check the existence of a user or group at the time of GRANT.
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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