Previous Topic: Locking and Unlocking UsersNext Topic: Deleting All Object Entities in the Catalog


Deleting Users from the Catalog

The DBA may need to permanently restrict a user's access to ASF. To revoke a user's access to ASF, the DBA must take the following steps:

  1. Delete all tables owned by the user. The user cannot be deleted from the catalog as long as the user owns tables. Alternatively, if CA-ICMS is installed, you can move the tables to a new owner.
  2. Access the User Maintenance screen, enter the user's ID In the User Name field, and select the Delete User function.

The user no longer has access to ASF and has been removed from the catalog. Note that if the user is deleted from IDD, the user's catalog entry is deleted automatically and it is not necessary to perform the Delete User function on the User Maintenance screen.