rightsGrant_db2zOS.sql 767 B

1234567891011121314151617181920
  1. -- Licensed Materials - Property of IBM
  2. -- BI and PM: Mobile
  3. -- (C) Copyright IBM Corp. 2007, 2012
  4. -- US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
  5. --
  6. -- This script grants the tablespaces use rights for IBM DB2 on z/OS.
  7. --
  8. -- Modifications:
  9. --
  10. -- 1) Change COGMOBDB to the desired database name.
  11. -- 2) Change MOBUSR to the desired user name.
  12. ------------------------------------------------------------------------
  13. --*GRANT of Tablespaces' USE RIGHTS --
  14. ------------------------------------------------------------------------
  15. GRANT USE OF TABLESPACE COGMOBDB.COGMOBTS TO MOBUSR
  16. /
  17. GRANT USE OF TABLESPACE COGMOBDB.MOBTSL01 TO MOBUSR
  18. /