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

    Unanswered: Calling DB2 procedure with specified userid


    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.


  2. #2
    Join Date
    Jan 2003
    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.


Posting Permissions

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