Resources › DB2SYS Resource Class—Secure DB2 Privileges and Authorities › Examples: DB2SYS resource class

Examples: DB2SYS resource class

This example gives the Investment Department (INVDEPT) ownership of the SYSADM privilege:

TSS ADDTO(INVDEPT) DB2SYS(SYSADM)

This example removes ownership of a system privilege:

TSS REMOVE(INVDEPT) DB2SYS(SYSADM)

This example authorizes USRJIM to create a storage group:

TSS PERMIT(USRJIM) DB2SYS(CRESG)

This example revokes USRJIM's Authority to create a storage group:

TSS REVOKE(USRJIM) DB2SYS(CRESG)

This example authorizes USRMARK as a bind agent for USRMIKE's packages:

TSS PERMIT(USRMARK) DB2SYS(BINDAGENT.USRMIKE)

This example revokes USRMARK's Authority as USRMIKE's bind agent:

TSS REVOKE(USRMARK) DB2SYS(BINDAGENT.USRMIKE)