Resources › DB2DBASE Resource Class—Secure DB2 Databases › Examples: DB2DBASE resource class

Examples: DB2DBASE resource class

This example gives the Finance Department (FINDEPT) ownership of the database ACCTING:

TSS ADDTO(FINDEPT) DB2DBASE(ACCTING)

This example removes ownership of the database ACCTING :

TSS REMOVE(FINDEPT) DB2DBASE(ACCTING)

This example authorizes USRJANE to create new tables on database ACCTING:

TSS PERMIT(USRJANE) DB2DBASE(ACCTING)
                    ACCESS(CRETAB)

This example revokes USRJANE's Authority to access databases ACCTING:

TSS REVOKE(USRJANE) DB2DBASE(ACCTING)