Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2012
    Posts
    26

    Unanswered: Grant privileges on nickname

    please help me with the commend to Grant select,update,delete,insert privileges on some nickname for few users.



    NICKNAME
    PRODCAT.PC_RULE_MSTR_NICK
    PRODCAT.PC_RULE_CONDITION_PARAM_VALUE_NICK
    PRODCAT.PC_CONDITION_PARAM_MSTR_NICK

    USERS
    PREUSER
    PRODCAT
    DEFP

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Oct 2012
    Posts
    26
    GRANT ALL ON NICKNAME PRODCAT.PC_RULE_CONDITION_PARAM_VALUE_NICK TO USER PREUSER

    Error:
    ---------------
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL0104N An unexpected token "PRODCAT" was found following "RANT ALL ON
    NICKNAME". Expected tokens may include: "<space>". SQLSTATE=42601

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Get rid of "NICKNAME". It is not in the syntax diagram.

    Andy

  5. #5
    Join Date
    Oct 2012
    Posts
    26
    still not working say not a valid SQL

  6. #6
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Quote Originally Posted by basith.bd View Post
    still not working say not a valid SQL
    What exactly did you try, and what error message did you get?

    Andy

Posting Permissions

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