Delete authority collection repository
The authority collection repository for a user can be deleted. The authority collection repository for objects can be deleted or information for an object or group of objects can be deleted.
To save the authority collection data before DLTAUTCOL is used, it must first be written to a Db2® table (*FILE object) by using the provided view support. See Display authority collection data for an example of writing the authority collection data to a table.
Authority collection for a user
The Delete Authority Collection (DLTAUTCOL) command specifying TYPE(*USRPRF) and a profile name deletes the authority collection repository for the specified user. Deleting the authority collection repository deletes all authority collection information for the specified user. The authority collection repository can also be deleted when the Start Authority Collection (STRAUTCOL) command is run by using the DLTCOL(*YES) parameter.
Authority collection for objects
The DLTAUTCOL command specifying TYPE(*OBJ) and an object name deletes the authority collection information for the specified object or group of objects. The object repository is not deleted because it is a common repository for all information when collecting authority information for objects. The common object repository can be deleted with the DLTAUTCOL TYPE(*OBJ) OBJ(*ALL) command. The common object repository can also be deleted when the Start Authority Collection (STRAUTCOL) TYPE(*OBJAUTCOL) command is run by using the DLTCOL(*ALL) parameter. Deleting the common object repository deletes the authority collection information for all objects.