IKYSGRNT

IKYSGRNT is a sample that grants execute privilege on the DB2® package for PKI Services to the PKI Services daemon user ID.

Note: The following listing might not be identical to the code sample shipped with the product. For the most current sample, see SYS1.SAMPLIB member IKYSGRNT.

--**********************************************************************
--* SAMPLE: IKYSGRNT
--*
--* Licensed Materials - Property of IBM
--* 5650-ZOS
--* Copyright IBM Corp.  2013
--* Status = HKY7790
--*
--**********************************************************************
--
-- This sample may be used to grant execute privilege through SPUFI
-- on the DB2 package for PKI Services to the PKI Services daemon
-- user ID.
--
--**********************************************************************
--
-- Before using this sample, you may need to make the following
-- modifications:
--
-- 1) Change 'MASTERCA' to the package name that was used in the
--    IKYSBIND sample JCL file.  The package name should match the
--    first eight characters of the associated CA domain name and
--    match the value used when creating the DB2 database,
--    tablespaces, tables, and indexes in the IKYCDB2 sample file.
--
-- 2) Change 'PKISRVD' to match the value for the PKI Services daemon
--    user ID name.  The value to use should match the value used for
--    the variable 'daemon' in the IKYSETUP sample file.
--
-- You will also need certain DB2 privileges to use this sample.  To
-- use this sample, you will need at least one of the following DB2
-- privileges:
--     - EXECUTE privilege WITH GRANT OPTION on the
--       package named in the GRANT instruction below
--     - Ownership of the package named in the GRANT
--       instruction below
--     - SYSADM authority
--
--**********************************************************************
-- Change Activity:
--
--   $L0=PKIS21D      HKY7790   120612  PDRRG1: DB2 Enhancements
--
-- Change Description:
--
--   A: Initial code                                               @L0A
--
--**********************************************************************
GRANT EXECUTE ON PACKAGE MASTERCA.* TO PKISRVD;
                                               
COMMIT;