Try OpenEdge Now
skip to main content
Database Administration
Protecting Your Data : Maintaining Security : Connection security : Deleting a user from the _User table accounts
 
Deleting a user from the _User table accounts
Only security administrators can delete users from the _User table accounts.
To delete a user from the _User table accounts:
1. Choose Admin > Security > Edit User List from the graphical Data Administration tool or the character Data Dictionary. The Edit User List dialog box appears.
2. Select the user you want to delete, then click Delete. You are prompted to verify that you want to remove that user record. You cannot delete your own record until all other existing user records are deleted.
3. Verify that you want to delete the user record.
If you delete all user records from the _User table accounts, you are prompted to confirm that you want to remove all security restrictions for the database. If you verify the deletions, all users have security administrator privileges when they connect to the database. If you choose No, you must add one or more users to the _User table accounts before you can exit to the main window.