Try OpenEdge Now
skip to main content
DataServer for Oracle
Configuring the DataServer : Creating, Maintaining, and Deploying a schema holder : Schema holder security : Permissions for creating a schema holder
 
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$

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