| 1234567891011121314151617181920212223242526272829303132333435 |
- -- 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;
|
