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.

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$