Results 1 to 7 of 7
  1. #1
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1

    Unanswered: privileges for a user execute procedure.

    Hi Colleagues,

    There are in DB2 V9.5 a command for give a user privileges for execute procedure in DB2 V9.5 on AIX in command line?

    Thank you for advanced.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Not a command, but an SQL statement: GRANT

  3. #3
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1
    Hi Colleagues,

    I have a user in the database, I need that this user can to do BIND en DB2 9.5 on AIX. ¿What is the Authorization necesary for the user?.

    Thank you for advanved.

  4. #4
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1
    If this user execute a file.bnd for example: db2 bind miapl.bnd the system show the error: that not have authorization.

  5. #5
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    It is still the GRANT statement: IBM DB2 9.5 Information Center for Linux, UNIX, and Windows

    Andy

  6. #6
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1
    Hi,

    My question is very easy, this is an example: In the database there are 1000 packages. but this packages to belong to schemas and users aaaa, bbbb and cccc. Later I create the schema and user dddd. The question is, I need execute the 1000 packages that to belong to schemas and users aaaa, bbbb and cccc. Somebody can explain me the steps for the schema and user dddd can execute this 1000 packages.

    Any help is welcome.

    Thank you.

  7. #7
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Quote Originally Posted by georgipa View Post
    Hi,

    My question is very easy, this is an example: In the database there are 1000 packages. but this packages to belong to schemas and users aaaa, bbbb and cccc. Later I create the schema and user dddd. The question is, I need execute the 1000 packages that to belong to schemas and users aaaa, bbbb and cccc. Somebody can explain me the steps for the schema and user dddd can execute this 1000 packages.

    Any help is welcome.

    Thank you.
    We have told you several times. It is the GRANT statement. Please read the manual to see its usage.

    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
  •