When you use the DataServer to create a schema image in a schema holder, it accesses the associated Oracle Server database. This section describes the data source permissions required when you create, update, or connect to a schema image.To connect a schema holder for an Oracle database, you must provide a valid user ID and password combination for Oracle at connection time. Use the User ID (-U) parameter to provide the user ID and the Password (-P) parameter to provide the password. The allowed length for user ID and Password is 30 characters each.

Once you have set up the schema holder, the required Oracle privileges vary among users depending on their applications. For example, the user running an OpenEdge application that queries, but does not update, a table in the Oracle database must connect to the Oracle database with a user and password that provides at least SELECT privileges on the table.

Note: In addition to the permissions required by the applications that users run, users must have SELECT permission on the sys.dual system table.

In summary, the user ID and password combination required to run an application depends on:

  • The Oracle database tables the application accesses
  • The type of access required on those tables
Note: A database administrator (DBA) must establish all user ID and password combinations within Oracle.