Database Object Security
By default, all Oracle Application Express applications and RESTful Web Services execute with the privileges of the schema owner. You can create users within the Oracle Application Express environment and use authentication schemes to limit access to application objects at all levels in your application through Oracle Application Express.
You cannot use a GRANT command to assign access to another user, since other schema owners are not allowed to access your schema objects in the schema-isolation multitenant environment of the Oracle Database Cloud Schema Service.
You can also assign security across multiple dimensions, including origin, application and users, for any RESTful Web Services. See Security and Oracle Database Cloud Schema Service.
Topics:
Database Object Limitations
The following limitations apply to the DDL (Data Definition Language), syntax:
-
You cannot use any PARALLEL syntax in defining tables.
-
You cannot use quoted identifiers with special characters.
-
You cannot define BFILEs or external LOBs.
-
You cannot use external tables.
-
You cannot specify any caching for database objects.