Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2012
    Posts
    15

    Unanswered: Calling DB2 procedure with specified userid

    Hi

    I have an export command that runs using the CALL SYSPROC.ADMIN_CMD but I see that the export files are being created with some other user id (than what is used to connect) and this id does not have access to our project folders

    Is there any means by which i can force the stored procedure to run with a specific id ? I have checked the CALL documentation but doesn't seem like it has got userid argument in it.

    Thanks
    -Zulfi

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    If I remember correctly, the user is the DB2 fenced user. You are just going to have to give this user the correct permissions as you cannot change it.

    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
  •