All users must supply a valid user ID and password to access an Oracle database. In addition, Oracle provides security in the form of 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 OpenEdge DataServer for Oracle, there are three security requirements:

  • To create the schema holder for the Oracle database, you must have sufficient privileges to connect and create a session and select privileges for system objects in the Oracle 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. OpenEdge provides connection parameters that the DataServer uses to pass this information to the Oracle Database Manager.

See Schema holder security for a detailed description of the required privileges.