Resources › DB2TABSP Resource Class—Secure DB2 Table Spaces › Examples: DB2TABSP resource class

Examples: DB2TABSP resource class

This example gives the Finance Department (FINDEPT) ownership of the table space TSPACE1 that resides on database ACCTING:

TSS ADDTO(FINDEPT) DB2TABSP(ACCTING.TSPACE1)

This example removes ownership of the table space TSPACE1:

TSS REMOVE(FINDEPT) DB2TABSP(ACCTING.SPACE1)

This example authorizes USRMARK to access table space ACCTING.TSPACE1:

TSS PERMIT(USRMARK) DB2TABSP(ACCTING.TSPACE1)

This example revokes USRMARK's Authority to table space ACCTING.TSPACE1:

TSS REVOKE(USRMARK) DB2TABSP(ACCTING.TSPACE1)

This example gives FINVCA the ability to assign ownership of table spaces, to PERMIT user to access table spaces within his scope, and to audit the use of table spaces owned by the division:

TSS ADMIN(FINVCA) DB2TABSP(OWN,XAUTH,INFO)

This example removes FINVCA's Authority for table spaces:

TSS DEADMIN(FINVCA) DB2TABSP(OWN,XAUTH,INFO)