Packages if these packages are not granted EXECUTE to ORDS_METADATA is granted EXECUTE on the following PUBLIC is granted EXECUTE on PL/SQL packages that are available for users to invoke.
PUBLIC is granted SELECT on many ORDS_METADATA tables and views. The APEX_ users are created during the Oracle Application Express installation process.Īs part of the Oracle REST Data Services installation, privileges are granted to several users: User for invoking RESTful Services in the Oracle REST Data Services-enabled schemas. 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
0 kommentar(er)
