Periodically, you might need to delete obsolete user profiles from the Q.PROFILES table. Delete a user profile from Q.PROFILES when you are sure that objects created by the primary authorization ID in that profile have been either deleted or safely transferred to other users:
Use a query similar to the one shown in Figure 76 to delete a user profile.
If you are using an NLF: Include a value for the TRANSLATION column if you want to delete the user profile in a single NLF environment. If you do not specify a value for TRANSLATION, QMF deletes the profile in all NLF environments.
If the user whose profile you deleted had a private dbspace, use the SQL DROP DBSPACE statement from the SQL query panel if the space contains nothing you want to save. Also, you can use the SQL DROP TABLE statement or QMF ERASE commands if you want to delete specific QMF or database objects. The DB2 for VSE & VM SQL Reference manual explains the DROP statement. The QMF Reference manual explains the ERASE command.
When you delete a user profile, all SQL privileges the user had on objects are deleted, as well as all privileges that the user granted to other users. To ensure other users will not be affected, query the SYSTEM.SYSTABAUTH table to see what SQL privileges have been granted to the user. Query the SYSTEM.SYSUSERAUTH table to see what DB2 authorities have been granted.
[ Previous Page | Next Page | Contents | Index ]