Progress
DataServer
for ORACLE Guide
Security
Using the DataServer involves following the security guidelines required by both Progress and ORACLE. By default, Progress does not impose security on databases, so at a minimum, you follow the guidelines ORACLE requires for your applications.
Progress Security
The Progress database management system has no minimum security requirements. You can, however, impose security features on any Progress database or schema holder. There are four levels of application security you can impose: database-connection security, schema security, compile-time security, and run-time security. See the Progress Programming Handbook for more information.
ORACLE Security
All users must supply a valid user ID and password to access an ORACLE database. In addition, ORACLE provides security in the form of over 60 distinct privileges that control access to databases and objects within databases. ORACLE regulates access to database objects at the table level based on types of tasks. For example, INDEX privileges allow the user to create or drop indexes.
The DataServer does not support Trusted ORACLE.
To use the DataServer for ORACLE, there are three security requirements:
- To create the schema holder for the ORACLE database, you must have SELECT privileges for system objects in the ORACLE database. The privileges required to access the schema holder and connect to the ORACLE database with the DataServer depend on whether and how your application modifies the database.
- To run DataServer applications that access an ORACLE database, you must have SELECT privileges for the sys.dual system table.
- To connect to the schema holder for the ORACLE database, you must supply a valid user ID and password for the target database. Progress provides connection parameters that the DataServer uses to pass this information to the ORACLE Database Manager.
The "Schema-holder Security" section in "Configuring the DataServer," describes the required privileges in detail.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |