Progress
Database Administration
Guide and Reference
Designating a Security Administrator
If you establish a list of valid user IDs, you must designate one user, or preferably more than one user, as security administrator. The security administrator is responsible for maintaining the security information in the database. Typically, the database administrator also serves as security administrator. Progress allows you to designate security administrators only if you have connected to the database with a nonblank user ID and if your user ID is already in the user list. You can then designate yourself, and preferably another user, as security administrators.
Once you designate security administrators, only they can access the following Data Dictionary utilities on the Security menu:
All users can access the other two utilities in the Security submenu: Change Your Password and Quick User Reports. Note that designating security administrators does not limit other users’ ability to create new tables or fields in the database.
You can designate security administrators by using one of three utilities: Edit User List (CallAdmin option), Change/Display Data Security (CallAdmin option), and Security Administrators. These utilities allow you to access the same screen, where you follow these steps to enter user IDs for security administrators:
- Access the Data Administration tool if you are using a graphical interface or access the Data Dictionary if you are using a character interface. The following steps represent the graphical interface.
- Choose Admin
Security
Security Administrators. The Security Administrators dialog box appears:
![]()
- You can enter many user IDs here, but you must include your own user ID. Otherwise, the following error message appears:
Use commas, not spaces, to separate user IDs. If you use spaces in the string, they will be accepted as part of the string.
- When you are done entering user IDs, choose OK. The Data Dictionary prompts you to verify the security administrator entries.
Verify that you want to save the entries. The Data Dictionary stores these user IDs as security administrators for the database.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |