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.
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.
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.
Table 10–7 describes the options at the bottom of the Edit Data Security dialog box.
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 |