

To perform installation using TNS connection, enter the followingĬommand: java _admin=/path/to/tnsFolder -jar ords.war install ORDS, then you must specify the _admin system property on theĬommand line that contains the folder with the tnsnames.ora file. Note:If you use a TNS connection to install ORDS_METADATA is granted the necessary object privileges to migrate Application Express REST data to ORDS_METADATA tables. ORDS_METADATA is granted the following system privileges:.WITH GRANT OPTION on the following views: ORDS_METADATA is granted SELECT including.READ (12 c or later) on the following views:

ORDS_METADATA is granted EXECUTE on the following.READ (12 c or later) on the following view if it is not


The schema password is set to a random string, connect privilege is revoked, and the password is expired. It is not accessed directly by Oracle REST Data Services the Oracle REST Data Services application never creates a connection to the ORDS_METADATA schema. ORDS_METADATA is where the metadata about Oracle REST Data Services-enabled schemas is stored. Owner of the PL/SQL packages used for implementing many Oracle REST Data Services capabilities. The database user used to query RESTful Services definitions stored in Oracle Application Express if RESTful Services defined in Application Express workspaces are being accessed The database user used when invoking Oracle Application Express RESTful Services if RESTful Services defined in Application Express workspaces are being accessed Only if using RESTful Services defined in Application Express of version 5.0 or above. If you use Oracle REST Data Services with Oracle Application Express, this is the database user used when invoking PL/SQL Gateway operations, for example, all Oracle Application Express operations.įor information on unlocking the APEX_PUBLIC_USER, see Configure APEX_PUBLIC_USERĪccount in Oracle Application Express Installation Only if using Oracle REST Data Services with Oracle Application Express
