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

    Unanswered: With grant option

    I am using SQLDBX as my tool for IBM DB2 LUW 9.5.

    Each time I create new tables / modify existing tables I need to use the grant option to assign privileges to users.

    I have a question though regarding the WITH GRANT OPTION command.

    While my grant statement executes without any error a WITH GRANT doesn't.

    For example WITH GRANT OPTION SELECT ON SCHEMA.TABLE TO USER; results in an error message stating Unexpected character /text.

    Can someone please clarify?



  2. #2
    Join Date
    Apr 2006
    Provided Answers: 11
    grant select on table xx.yy to user uuu with grant option
    means user uuu can forward the grant
    IBM Knowledge Center
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5-V11 Fundamentals- DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified

Posting Permissions

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