Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2002
    Location
    Belarus, Minsk
    Posts
    7

    Unhappy Unanswered: how to grant privileges on package (stored proc)

    We use DB2 v7.1 on Linux Red Hat.

    I created a stored proc using under admin

    Then I don't know how to grant privilegs on this proc to user db users and they can't call it

    The user has priviliges on all he tables, which the proc uses

  2. #2
    Join Date
    Jan 2002
    Posts
    165
    You have to be connected on db as user with DBADM,SYSADM or user who have CONTROL on that package.
    After that,be sure user have CONNECT privilege( you can do this with
    db2 grant connect on database to user <username>.
    At the end:
    db2 grant execute on package <package_name> to user <username>.

    Cheers,Zvonimir

  3. #3
    Join Date
    Dec 2002
    Location
    Belarus, Minsk
    Posts
    7

    Talking

    Originally posted by zkajfez
    You have to be connected on db as user with DBADM,SYSADM or user who have CONTROL on that package.
    After that,be sure user have CONNECT privilege( you can do this with
    db2 grant connect on database to user <username>.
    At the end:
    db2 grant execute on package <package_name> to user <username>.

    Cheers,Zvonimir
    Zvonimir, thank you very much

    It works now!

Posting Permissions

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