-- Licensed Materials - Property of IBM
-- IBM Cognos Products: ccllogging
-- (C) Copyright IBM Corp. 2005, 2013
-- US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp. 

-- This script grants the tablespaces use rights for
--  IBM DB2 for z/OS 
--
--  Modifications:
--
--  1) Changed IPFSCRIPT_DATABASE to the desired db name.
--  2) Changed IPFSCRIPT_USERNAME to the desired user name. 
--  3) Replace IPFSCRIPT_LS_ID with a unique audit database ID, no more than two character long, with literal first character 
--  4) Replace IPFSCRIPT_TABLESPACE  with a name of the tablespace, allocated for base tables

------------------------------------------------------------------------
--*GRANT of Tablespaces' USE RIGHTS                                   --
------------------------------------------------------------------------
 GRANT USE OF  TABLESPACE  IPFSCRIPT_DATABASE.IPFSCRIPT_TABLESPACE TO IPFSCRIPT_USERNAME; 
  
 GRANT USE OF  TABLESPACE  IPFSCRIPT_DATABASE.IPFSCRIPT_LS_IDIPFL01 TO IPFSCRIPT_USERNAME; 
 
 GRANT USE OF  TABLESPACE  IPFSCRIPT_DATABASE.IPFSCRIPT_LS_IDIPFL02 TO IPFSCRIPT_USERNAME; 
 
 GRANT USE OF  TABLESPACE  IPFSCRIPT_DATABASE.IPFSCRIPT_LS_IDIPFL03 TO IPFSCRIPT_USERNAME; 
 
 GRANT USE OF  TABLESPACE  IPFSCRIPT_DATABASE.IPFSCRIPT_LS_IDIPFL04 TO IPFSCRIPT_USERNAME; 
 
 GRANT USE OF  TABLESPACE  IPFSCRIPT_DATABASE.IPFSCRIPT_LS_IDIPFL05 TO IPFSCRIPT_USERNAME; 
 
 GRANT USE OF  TABLESPACE  IPFSCRIPT_DATABASE.IPFSCRIPT_LS_IDIPFL06 TO IPFSCRIPT_USERNAME; 
 
 GRANT USE OF  TABLESPACE  IPFSCRIPT_DATABASE.IPFSCRIPT_LS_IDIPFL07 TO IPFSCRIPT_USERNAME; 
 
 commit;
