Release 10.1A: OpenEdge Data Management:
Database Administration

> ## 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. OpenEdge 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 options on the Data Dictionary’s Security menu:

> - Edit User List.

> - Change/Display Data Security.

> - Security Administrators.

> - Disallow Blank Userid Access.

> All users can access the other two options in the Security menu: 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 choosing one of three options in the Data Dictionary’s Security menu: Edit User List, Edit Data Security, and Security Administrators. These utilities allow you to access the same screen, where you enter user IDs for security administrators.

> | To enter user IDs for security administrators:

> 1. 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.

> 2. Choose Admin Security Security Administrators. The Security Administrators dialog box appears:

> 3. You can enter many user IDs here, but you must include your own user ID. Otherwise, the following error message appears:

>     You cannot change a security field to exclude yourself.

> Use commas, not spaces, to separate user IDs. If you use spaces in the string, they will be accepted as part of the string.

> 4. 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 © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095