Previous Topic: DB2STOGP Resource Class—Secure DB2 Storage GroupsNext Topic: DB2SYS Resource Class—Secure DB2 Privileges and Authorities

Resources › DB2STOGP Resource Class—Secure DB2 Storage Groups › Examples: DB2STOGP Resource Class

Examples: DB2STOGP Resource Class

This example gives the Operations Department (OPRDEPT) ownership of the storage group TESTDASD:

TSS ADDTO(OPRDEPT) DB2STOGP(TESTDASD)

This example removes ownership of the table TESTDASD:

TSS REMOVE(OPRDEPT) DB2STOGP(TESTDASD)

This example authorizes USRMARK to access storage group TESTDASD:

TSS PERMIT(USRMARK) DB2STOGP(TESTDASD)

This example revokes USRMARK's Authority to buffer pool TESTDASD:

TSS REVOKE(USRMARK) DB2STOGP(TESTDASD)