Permissions for creating a schema holder

DataServer for Oracle

Configuring the DataServer : Creating, Maintaining, and Deploying a schema holder : Schema holder security : Permissions for creating a schema holder

You must have privileges to use the SELECT statement on certain data source objects to perform certain tasks. In this chapter, these privileges are referred to as SELECT privileges.

For example, when you create or update a schema holder for an Oracle database, you must be able to connect to the database and have SELECT privileges on specific system objects. SELECT privileges on system objects are required because the Data Dictionary cannot access the Data Dictionary tables in the Oracle database without them; it must access those tables to create a schema holder.

The following table describes the permissions that you need for creating a schema holder.

Table 31. Required Oracle permissions
Permission	Object
CREATE SESSION	Database
SELECT	System objects: sys.argument$ sys.ccol$ sys.cdef$ sys.col$ sys.com$ sys.con$ sys.dual sys.icol$ sys.ind$ sys.link$1 sys.obj$ sys.procedure$ sys.seq$ sys.syn$ sys.tab$ sys.ts$ sys.user$ sys.view$ ¹

¹ SELECT privileges are typically not provided to the Database Administrator (DBA).