To give the Finance Department (FINDEPT) ownership of the database ACCTING, the administrator enters:
TSS ADD(FINDEPT) DB2DBASE(ACCTING)
Ownership of the database ACCTING is removed by entering:
TSS REMOVE(FINDEPT) DB2DBASE(ACCTING)
The administrator wants to authorize USRJANE to create new tables on database ACCTING. He enters:
TSS PERMIT(USRJANE) DB2DBASE(ACCTING) ACCESS(CRETAB)
To revoke USRJANE's authority to access databases ACCTING, he enters:
TSS REVOKE(USRJANE) DB2DBASE(ACCTING)
To give administrator FINVCA the ability to assign database ownership, permit users to access databases within his scope, and audit the use of a database owned by the division, the administrator enters:
TSS ADMIN(FINVCA) DB2DBASE(OWN,XAUTH,INFO)
To remove FINVCA's authority for databases, the administrator enters:
TSS DEADMIN(FINVCA) DB2DBASE(OWN,XAUTH,INFO)
To determine who has access to the database ACCTING, the administrator enters:
TSS WHOHAS DB2DBASE(ACCTING)
CA Top Secret will respond by displaying all of the ACIDs that have access to this particular database.
To determine who owns the database ACCTING, the administrator enters:
TSS WHOOWNS DB2BASE(ACCTING)
|
Copyright © 2011 CA Technologies.
All rights reserved.
|
|