Progress
Basic Database
Tools


Admin>Security

Choose the Security option to perform the following tasks:

Table 10–4 describes the menu that appears when you choose this option. More detailed descriptions of the options follow the table. See also the Progress Database Administration Guide and Reference and the Progress Client Deployment Guide for more information on security administration.

Table 10–4: Security Menu 
Security

Edit User List...

Modifies the user list.

Change Your Password...

Changes your password.

Edit Data Security...

Defines access to security tables and fields.

Security Administrators...

Designates security administrators.

Disallow Blank Userid Access...

Denies blank user IDs access to the working database.

User Report...

Displays or print user information.

Security Edit User List

Choose Security Edit User List to add or delete users from the user list. You can also change the user name. When you choose this option, the Edit User List window shown in Figure 10–4 appears.

Figure 10–4: Edit User List Window

This window contains the following user-interface elements:

User ID

Lists the users defined for the working database.

User Name

Displays the user name of the selected user.

Password

Indicates whether the selected user has been assigned a password.

Table 10–5 describes the options at the bottom of the Edit User List window.

Table 10–5: Edit User List Window Options
Option
Action
Next
Highlights the next user in the user list.
Prev
Highlights the previous user in the user list.
First
Highlights the first user in the user list.
Last
Highlights the last user in the user list.
Add
Adds a new user.
Modify
Modifies the selected user’s name.
Delete
Deletes the selected user ID.
CallAdmin
Accesses the Security Administrators dialog box.
Security
Accesses the Data Security option dialog box.
Report
Generates a user report for the working database.
Undo
Discards any changes you made and exits to the Data Dictionary window.
Exit
Exits, saves changes, and returns to the Data Dictionary window.

Once you designate security administrators, only they can edit the user list.

Security Change Your Password

Choose this option to change your password. Progress prompts you for your new password. Enter your new password, then choose OK. Remember that passwords are case sensitive. Progress prompts you to verify the new password.

Progress allows all users to change their own passwords.

Security Edit Data Security

Choose Security Edit Data Security to define compile-time security for an application database. Progress alphabetically lists the names of the tables defined for the working database. When you select a table, Progress displays the current permissions lists for the table. Figure 10–5 shows the default permissions for the customer table.

Figure 10–5: Edit Data Security Dialog Box

The upper section of the dialog box displays the six levels of security permissions for the table. By default, Progress initializes all levels with an asterisk (*), which means that all users are allowed to modify table permissions. The lower section describes the syntax for the permissions lists.

The six levels of security permissions for tables are:

Can-Read

Specifies the users who have permission to read a table. The default is an asterisk (all users).

Can-Write

Specifies the users who can write to a table or update records. The default is an asterisk (all users).

Can-Create

Specifies the users who can create new records. In order to create a new record, a user must have Can-Write privileges. The default is an asterisk (all users).

Can-Delete

Specifies the users who can delete records from a table. The default is an asterisk (all users).

Can-Dump

Specifies whether you can dump database or table definitions and data with triggers disabled. The default is an asterisk (all users).

Can-Load

Specifies whether you can load database or table definitions and data with triggers disabled. The default is an asterisk (all users).

Table 10–6 describes the values you use to define the permissions for a table.

Table 10–6: Access Restrictions for Tables 
Expression
Meaning
*
All users are allowed access.
user
Only this user has access.
! user, *
All users have access except this user.1
acct*
User IDs that begin with acct have access.
  1. Do not place the asterisk (*) before !user. If you do, all users are allowed access.

Table 10–7 describes the options at the bottom of the Edit Data Security dialog box.

Table 10–7: Edit Data Security Dialog Box Options
Option
Action
NextField
Displays the next field defined for the specified table.
PrevField
Displays the previous field defined for the specified table.
ForwardFile
Displays the permissions for the next table defined for the working database.
Modify
Modifies the permissions for a table or field.
SwitchFile
Displays the list of tables again so you can select a new table.
JumpField
Displays a list of all the fields defined for the current table.
CallAdmin
Accesses the Security Administrators dialog box.
Security
Accesses the Data Security option dialog box.
Report
Generates a user report for the working database.
Exit
Exits, saves changes, and returns to the Data Dictionary window.

Once you designate security administrators, only they can use this option.

Security Security Administrators

Choose Security Security Administrators to designate a security administrator. The Security Administrators dialog box shown in Figure 10–6 appears.

Figure 10–6: Security Administrators Dialog Box

You can enter many user IDs here, but you must include your own user ID. Separate the user IDs with commas, but no spaces. When you are done entering the user IDs, choose OK. Progress prompts you to verify the entries you made.

Once you designate security administrators, only they can use this option.

Security Disallow Blank User Access

Choose this option to prevent users who are not listed in the user list from accessing the working database. When you choose this option, Progress displays an alert box prompting you to verify that you want to prevent blank user ID access to the database.

Security User Report

Choose Security User Report to display or print a list of user IDs and user names, as well as to determine which user IDs are protected by passwords. When you choose this option, Progress displays the user ID list, as shown in Figure 10–7.

Figure 10–7: User Report Dialog Box

To send the report to a file or printer, choose Print. Progress prompts you for the printer or filename, whether you want to append the report to an existing file, and the page length.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095