Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655

    Unanswered: Table Access for functions ??

    Hi,

    I am having problem assigning privildges to a user to tables in other schema in a function. May be bind authority or something that I am missing ??


    DB2v9.5.5 on Win2k3

    DBFinder

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    That is because you cannot use GRANT/REVOKE in a function:

    IBM DB2 9.5 Information Center for Linux, UNIX, and Windows

    You can use GRANT in a Stored Procedure, but not REVOKE, so if all you need is GRANT, then you can write a Stored Procedure and wrap your function around the SP.

    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
  •