Delete authority collection repository

The authority collection repository for a user can be deleted. Start of change The authority collection repository for objects can be deleted or information for an object or group of objects can be deleted. End of change

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 Start of change specifying TYPE(*USRPRF) End of change 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.