Resources › DB2TABLE Resource Class—Secure DB2 Tables › Examples: DB2SYS Resource Class

Examples: DB2SYS Resource Class

This example gives the Payroll Department (PAYDEPT) ownership of the table USRMIKE.PAYR:

TSS ADDTO(PAYDEPT) DB2TABLE(USRMIKE.PAYR)

This example removes ownership of the table PAYR:

TSS REMOVE(PAYDEPT) DB2TABLE(USRMIKE.PAYR)

This example authorizes USRMARE to select the social security information on table USRMIKE.PAYR:

TSS PERMIT(USRMARE) DB2TABLE(USRMIKE.PAYR) ACCESS(SELECT)

This example revokes USRMARE's Authority to table USRMIKE.PAYR:

TSS REVOKE(USRMARE) DB2TABLE(USRMIKE.PAYR)

This example restricts a user's ability to update specifically‑named columns in a table. Authorize USRGAB with update privilege to correct any errors in the start‑date column on the USRMIKE.PAYR table:

TSS PERMIT(USRGAB) DB2TABLE(USRMIKE.PAYR.STRTDTE) ACCESS(UPDATE)

This example revokes USRGAB's Authority to table USRMIKE.PAYR:

TSS REVOKE(USRGAB) DB2TABLE(USRMIKE.PAYR)