Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2010
    Posts
    33

    Question Unanswered: Clarification on Create Procedure(Stored Procedure)

    Hi,

    Apart from SYSCTRL ,SYSADM access what are the other necessary previlege can be given to normal application user to create a procedure(stored Procedure). Here We are not interested to provide SYSCTRL or SYSADM to the normal users. Also, if DBADM is given to this user , what will be the right sytax to create Procedure.

    Version : DB2 V10.1
    OS : Z/OS 1.12

    Please guide me.

    Jags

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I suspect that if you look in the SQL Reference for z/OS, you will find that information under CREATE PROCEDURE.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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