home - keyword index

Keyword: USER

jump to Columns back to index

Tables

Table Name Description
ALL_REPCAT_USER_AUTHORIZATIONS
ALL_REPCAT_USER_PARM_VALUES
DBA_REPCAT_USER_AUTHORIZATIONS
DBA_REPCAT_USER_PARM_VALUES
USER_ALL_TABLES Description of all object and relational tables owned by the user's
USER_APPLICATION_ROLES
USER_AQ_AGENT_PRIVS
USER_ARGUMENTS Arguments in object accessible to the user
USER_ASSOCIATIONS All assocations defined by the user
USER_ATTRIBUTE_TRANSFORMATIONS
USER_AUDIT_OBJECT Audit trail records for statements concerning objects, specifically: table, cluster, view, index, sequence, [public] database link, [public] synonym, procedure, trigger, rollback segment, tablespace, role, user
USER_AUDIT_POLICIES All fine grained auditing policies for objects in user schema
USER_AUDIT_SESSION All audit trail records concerning CONNECT and DISCONNECT
USER_AUDIT_STATEMENT Audit trail records concerning grant, revoke, audit, noaudit and alter system
USER_AUDIT_TRAIL Audit trail entries relevant to the user
USER_AWS Analytic Workspaces owned by the user
USER_AW_PS Pagespaces in Analytic Workspaces owned by the user
USER_BASE_TABLE_MVIEWS All materialized views with log(s) owned by the user in the database
USER_CATALOG Tables, Views, Synonyms and Sequences owned by the user
USER_CLUSTERS Descriptions of user's own clusters
USER_CLUSTER_HASH_EXPRESSIONS Hash functions for the user's hash clusters
USER_CLU_COLUMNS Mapping of table columns to cluster columns
USER_COLL_TYPES Description of the user's own named collection types
USER_COL_COMMENTS Comments on columns of user's tables and views
USER_COL_PRIVS Grants on columns for which the user is the owner, grantor or grantee
USER_COL_PRIVS_MADE All grants on columns of objects owned by the user
USER_COL_PRIVS_RECD Grants on columns for which the user is the grantee
USER_CONSTRAINTS Constraint definitions on user's own tables
USER_CONS_COLUMNS Information about accessible columns in constraint definitions
USER_CONS_OBJ_COLUMNS List of types an object column or attribute is constrained to in the tables owned by the user
USER_DB_LINKS Database links owned by the user
USER_DEPENDENCIES Dependencies to and from a users objects
USER_DIMENSIONS Description of the dimension objects accessible to the DBA
USER_DIM_ATTRIBUTES Representation of the relationship between a dimension level and a functionally dependent column
USER_DIM_CHILD_OF Representaion of a 1:n hierarchical relationship between a pair of levels in a dimension
USER_DIM_HIERARCHIES Representation of a dimension hierarchy
USER_DIM_JOIN_KEY Representation of a join between two dimension tables.
USER_DIM_LEVELS Description of dimension levels visible to DBA
USER_DIM_LEVEL_KEY Representations of columns of a dimension level
USER_ERRORS Current errors on stored objects owned by the user
USER_EVALUATION_CONTEXTS rule evaluation contexts owned by user
USER_EVALUATION_CONTEXT_TABLES tables in user rule evaluation contexts
USER_EVALUATION_CONTEXT_VARS variables in user rule evaluation contexts
USER_EXTENTS Extents comprising segments owned by the user
USER_EXTERNAL_LOCATIONS Description of the user's external tables locations
USER_EXTERNAL_TABLES Description of the user's own external tables
USER_FREE_SPACE Free extents in tablespaces accessible to the user
USER_HISTOGRAMS Synonym for USER_TAB_HISTOGRAMS
USER_INDEXES Description of the user's own indexes
USER_INDEXTYPES All user indextypes
USER_INDEXTYPE_COMMENTS Comments for user-defined indextypes
USER_INDEXTYPE_OPERATORS All user indextype operators
USER_IND_COLUMNS COLUMNs comprising user's INDEXes and INDEXes on user's TABLES
USER_IND_EXPRESSIONS Functional index expressions in user's indexes and indexes on user's tables
USER_IND_PARTITIONS
USER_IND_SUBPARTITIONS
USER_INTERNAL_TRIGGERS Description of the internal triggers on the user's own tables
USER_JAVA_ARGUMENTS argument information of stored java class owned by the user
USER_JAVA_CLASSES class level information of stored java class owned by the user
USER_JAVA_DERIVATIONS this view maps java source objects and their derived java class objects and java resource objects for the java class owned by user
USER_JAVA_FIELDS field information of stored java class owned by the user
USER_JAVA_IMPLEMENTS interfaces implemented by the stored java class owned by user
USER_JAVA_INNERS list of inner classes refered by the stored java class owned by user
USER_JAVA_LAYOUTS class layout information about stored java class owned by the user
USER_JAVA_METHODS method information of stored java class owned by the user
USER_JAVA_NCOMPS ncomp related information of java classes owned by user
USER_JAVA_POLICY java security Permissions for current user
USER_JAVA_RESOLVERS resolver of java class owned by user
USER_JAVA_THROWS list of exceptions thrown from a method of a class owned by user
USER_JOBS All jobs owned by this user
USER_JOIN_IND_COLUMNS Join Index columns comprising the join conditions
USER_LIBRARIES Description of the user's own libraries
USER_LOBS Description of the user's own LOBs contained in the user's own tables
USER_LOB_PARTITIONS
USER_LOB_SUBPARTITIONS
USER_LOB_TEMPLATES
USER_LOG_GROUPS Log group definitions on user's own tables
USER_LOG_GROUP_COLUMNS Information about columns in log group definitions
USER_METHOD_PARAMS Description of method parameters of the user's own types
USER_METHOD_RESULTS Description of method results of the user's own types
USER_MVIEWS All materialized views in the database
USER_MVIEW_AGGREGATES Description of the materialized view aggregates created by the user
USER_MVIEW_ANALYSIS Description of the materialized views created by the user
USER_MVIEW_DETAIL_RELATIONS Description of the materialized view detail tables of the materialized views created by the user
USER_MVIEW_JOINS Description of a join between two columns in the WHERE clause of a materialized view created by the user
USER_MVIEW_KEYS Description of the columns that appear in the GROUP BY list of a materialized view created by the user
USER_MVIEW_LOGS All materialized view logs owned by the user
USER_MVIEW_REFRESH_TIMES Materialized views and their last refresh times for each master table that the user can look at
USER_NESTED_TABLES Description of nested tables contained in the user's own tables
USER_OBJECTS Objects owned by the user
USER_OBJECT_SIZE Sizes, in bytes, of various pl/sql objects
USER_OBJECT_TABLES Description of the user's own object tables
USER_OBJ_AUDIT_OPTS Auditing options for user's own tables and views
USER_OBJ_COLATTRS Description of object columns and attributes contained in tables owned by the user
USER_OPANCILLARY All ancillary opertors defined by user
USER_OPARGUMENTS All operator arguments of operators defined by user
USER_OPBINDINGS All binding functions or methods on operators defined by the user
USER_OPERATORS All user operators
USER_OPERATOR_COMMENTS Comments for user-defined operators
USER_OUTLINES Stored outlines owned by the user
USER_OUTLINE_HINTS Hints stored in outlines owned by the user
USER_PARTIAL_DROP_TABS User tables with unused columns
USER_PART_COL_STATISTICS
USER_PART_HISTOGRAMS
USER_PART_INDEXES
USER_PART_KEY_COLUMNS
USER_PART_LOBS
USER_PART_TABLES
USER_PASSWORD_LIMITS Display password limits of the user
USER_PENDING_CONV_TABLES All user's tables which are not upgraded to the latest type version
USER_POLICIES All row level security policies for synonyms, tables, or views owned by the user
USER_POLICY_CONTEXTS All policy driving context defined for synonyms, tables, or views in current schema
USER_POLICY_GROUPS All policy groups defined for any synonym, table, or view
USER_PROCEDURES Description of the users own procedures
USER_PROXIES Description of connections the user is allowed to proxy
USER_PUBLISHED_COLUMNS
USER_QUEUES All queues owned by the user
USER_QUEUE_PUBLISHERS
USER_QUEUE_SCHEDULES
USER_QUEUE_TABLES All queue tables created by the user
USER_REFRESH All the refresh groups
USER_REFRESH_CHILDREN All the objects in refresh groups, where the user owns the refresh group
USER_REFS Description of the user's own REF columns contained in the user's own tables
USER_REGISTERED_MVIEWS Remote materialized views of local tables currently using logs owned by the user
USER_REGISTERED_SNAPSHOTS Remote snapshots of local tables currently using logs owned by the user
USER_REGISTRY
USER_REPAUDIT_ATTRIBUTE Information about attributes automatically maintained for replication
USER_REPAUDIT_COLUMN Information about columns in all shadow tables for user's replicated tables
USER_REPCAT
USER_REPCATLOG Information about the current user's asynchronous administration requests
USER_REPCAT_REFRESH_TEMPLATES
USER_REPCAT_TEMPLATE_OBJECTS
USER_REPCAT_TEMPLATE_PARMS
USER_REPCAT_TEMPLATE_SITES
USER_REPCAT_USER_AUTHORIZATION
USER_REPCAT_USER_AUTHORIZATION
USER_REPCAT_USER_PARM_VALUES
USER_REPCAT_USER_PARM_VALUES
USER_REPCOLUMN Replicated columns for the current user's table in ascending order
USER_REPCOLUMN_GROUP All column groups of user's replicated tables
USER_REPCONFLICT
USER_REPDDL Arguments that do not fit in a single repcat log record
USER_REPFLAVORS Flavors current user created for replicated object groups
USER_REPFLAVOR_COLUMNS Replicated columns from current user's tables in flavors
USER_REPFLAVOR_OBJECTS Replicated user objects in flavors
USER_REPGENERATED Objects generated for the current user to support replication
USER_REPGENOBJECTS Objects generated for the current user to support replication
USER_REPGROUP Replication information about the current user
USER_REPGROUPED_COLUMN Columns in the all column groups of user's replicated tables
USER_REPGROUP_PRIVILEGES Information about users who are registered for object group privileges
USER_REPKEY_COLUMNS Primary columns for a table using column-level replication
USER_REPOBJECT Replication information about the current user's objects
USER_REPPARAMETER_COLUMN All columns used for resolving conflicts in user's replicated tables
USER_REPPRIORITY Values and their corresponding priorities in user's priority groups
USER_REPPRIORITY_GROUP Information about user's priority groups
USER_REPPROP Propagation information about the current user's objects
USER_REPRESOLUTION Description of all conflict resolutions for user's replicated tables
USER_REPRESOLUTION_METHOD All conflict resolution methods accessible to the user
USER_REPRESOLUTION_STATISTICS Statistics for conflict resolutions for user's replicated tables
USER_REPRESOL_STATS_CONTROL Information about statistics collection for conflict resolutions for user's replicated tables
USER_REPSCHEMA N-way replication information about the current user
USER_REPSITES N-way replication information about the current user
USER_RESOURCE_LIMITS Display resource limit of the user
USER_RESUMABLE Resumable session information for current user
USER_ROLE_PRIVS Roles granted to current user
USER_RSRC_CONSUMER_GROUP_PRIVS Switch privileges for consumer groups for the user
USER_RSRC_MANAGER_SYSTEM_PRIVS system privileges for the resource manager for the user
USER_RULES Rules owned by the user
USER_RULESETS Rulesets owned by the user: maintained for backward compatibility
USER_RULE_SETS Rule sets owned by the user
USER_RULE_SET_RULES Rules in user rule sets
USER_SECONDARY_OBJECTS All secondary objects for domain indexes
USER_SEGMENTS Storage allocated for all database segments
USER_SEQUENCES Description of the user's own SEQUENCEs
USER_SNAPSHOTS Snapshots the user can look at
USER_SNAPSHOT_LOGS All snapshot logs owned by the user
USER_SNAPSHOT_REFRESH_TIMES Synonym for USER_MVIEW_REFRESH_TIMES
USER_SOURCE Source of stored objects accessible to the user
USER_SOURCE_TABLES
USER_SOURCE_TAB_COLUMNS
USER_SQLJ_TYPES Description of the user's own types
USER_SQLJ_TYPE_ATTRS Description of attributes of the user's own types
USER_SQLJ_TYPE_METHODS Description of methods of the user's own types
USER_STORED_SETTINGS Parameter settings for objects owned by the user
USER_SUBPARTITION_TEMPLATES
USER_SUBPART_COL_STATISTICS
USER_SUBPART_HISTOGRAMS
USER_SUBPART_KEY_COLUMNS
USER_SUBSCRIBED_COLUMNS
USER_SUBSCRIBED_TABLES
USER_SUBSCRIPTIONS
USER_SUMMARIES Description of the summaries created by the user
USER_SUMMARY_AGGREGATES
USER_SUMMARY_DETAIL_TABLES
USER_SUMMARY_JOINS
USER_SUMMARY_KEYS
USER_SYNONYMS The user's private synonyms
USER_SYS_PRIVS System privileges granted to current user
USER_TABLES Description of the user's own relational tables
USER_TABLESPACES Description of accessible tablespaces
USER_TAB_COLS Columns of user's tables, views and clusters
USER_TAB_COLUMNS Columns of user's tables, views and clusters
USER_TAB_COL_STATISTICS Columns of user's tables, views and clusters
USER_TAB_COMMENTS Comments on the tables and views owned by the user
USER_TAB_HISTOGRAMS Histograms on columns of user's tables
USER_TAB_MODIFICATIONS Information regarding modifications to tables
USER_TAB_PARTITIONS
USER_TAB_PRIVS Grants on objects for which the user is the owner, grantor or grantee
USER_TAB_PRIVS_MADE All grants on objects owned by the user
USER_TAB_PRIVS_RECD Grants on objects for which the user is the grantee
USER_TAB_SUBPARTITIONS
USER_TRANSFORMATIONS
USER_TRIGGERS Triggers owned by the user
USER_TRIGGER_COLS Column usage in user's triggers
USER_TS_QUOTAS Tablespace quotas for the user
USER_TYPES Description of the user's own types
USER_TYPE_ATTRS Description of attributes of the user's own types
USER_TYPE_METHODS Description of methods of the user's own types
USER_TYPE_VERSIONS Description of each version of the user's types
USER_UNUSED_COL_TABS User tables with unused columns
USER_UPDATABLE_COLUMNS Description of updatable columns
USER_USERS Information about the current user
USER_USTATS All statistics on tables or indexes owned by the user
USER_VARRAYS Description of varrays contained in the user's own tables
USER_VIEWS Description of the user's own views
USER_WORKSPACES
top back to index

Columns

Column Name Description
APPLY_USER (DBA_APPLY) Current user who is applying the messages
APPLY_USER (ALL_APPLY) Current user who is applying the messages
DB_USER (DBA_2PC_PENDING) Oracle user name of the end-user at the topmost database
DB_USER (DBA_FGA_AUDIT_TRAIL) Database username who executes the query
LOG_USER (ALL_JOBS) USER who was logged in when the job was submitted
LOG_USER (DBA_JOBS) USER who was logged in when the job was submitted
LOG_USER (USER_JOBS) USER who was logged in when the job was submitted
OS_USER (DBA_FGA_AUDIT_TRAIL) OS username who executes the query
OS_USER (DBA_2PC_PENDING) operating system specific name for the end-user
OS_USER_NAME (GV$LOCKED_OBJECT)
OS_USER_NAME (V$LOCKED_OBJECT)
PARSING_USER_ID (V$SQL_REDIRECTION)
PARSING_USER_ID (GV$SQLAREA)
PARSING_USER_ID (GV$SQL)
PARSING_USER_ID (V$SQL)
PARSING_USER_ID (V$SQLAREA)
PARSING_USER_ID (GV$SQL_REDIRECTION)
PRIV_USER (ALL_JOBS) USER whose default privileges apply to this job
PRIV_USER (USER_JOBS) USER whose default privileges apply to this job
PRIV_USER (DBA_JOBS) USER whose default privileges apply to this job
RESOLVE_USER (USER_WORKSPACES)
RESOLVE_USER (ALL_WORKSPACES)
RESOLVE_USER (DBA_WORKSPACES)
SCHEMA_USER (USER_JOBS) select * from bar means select * from schema_user.bar
SCHEMA_USER (DBA_JOBS) select * from bar means select * from schema_user.bar
SCHEMA_USER (ALL_JOBS) select * from bar means select * from schema_user.bar
SET_BY_USER (DBA_APPLY_PARAMETERS) YES if the value is set by the user, NO otherwise
SET_BY_USER (DBA_CAPTURE_PARAMETERS) YES if the value is set by the user, NO otherwise
SET_BY_USER (ALL_APPLY_PARAMETERS) YES if the value is set by the user, NO otherwise
SET_BY_USER (ALL_CAPTURE_PARAMETERS) YES if the value is set by the user, NO otherwise
USER (V$SORT_USAGE)
USER (V$TEMPSEG_USAGE)
USER (GV$TEMPSEG_USAGE)
USER (GV$SORT_USAGE)
USER# (GV$SESSION)
USER# (V$SESSION)
USER_BIND_PEEK_MISMATCH (GV$SQL_SHARED_CURSOR)
USER_BIND_PEEK_MISMATCH (V$SQL_SHARED_CURSOR)
USER_BLOCKS (DBA_TEMP_FILES) Size of the useful portion of file in ORACLE blocks
USER_BLOCKS (DBA_DATA_FILES) Size of the useful portion of file in ORACLE blocks
USER_BYTES (DBA_DATA_FILES) Size of the useful portion of file in bytes
USER_BYTES (DBA_TEMP_FILES) Size of the useful portion of file in bytes
USER_COMMENT (ALL_QUEUES) User specified comment
USER_COMMENT (USER_QUEUE_TABLES) User specified comment
USER_COMMENT (DBA_QUEUES) User specified comment
USER_COMMENT (DBA_QUEUE_TABLES) User specified comment
USER_COMMENT (ALL_QUEUE_TABLES) User specified comment
USER_COMMENT (USER_QUEUES) User specified comment
USER_ID (USER_USERS) ID number of the user
USER_ID (DBA_USERS) ID number of the user
USER_ID (DBA_RESUMABLE) User who own this resumable session
USER_ID (ALL_USERS) ID number of the user
USER_NAME (DBA_REPCAT_EXCEPTIONS) User name of user submitting the exception.
USER_NAME (USER_REPCAT_TEMPLATE_SITES) Database user name.
USER_NAME (V$OPEN_CURSOR)
USER_NAME (DBA_IAS_SITES)
USER_NAME (DBA_EXP_FILES) Name of user who executed export
USER_NAME (ALL_REPCAT_USER_PARM_VALUES) Database user name.
USER_NAME (DBA_SUBPARTITION_TEMPLATES)
USER_NAME (GV$OPEN_CURSOR)
USER_NAME (ALL_SUBPARTITION_TEMPLATES)
USER_NAME (DBA_STMT_AUDIT_OPTS) User name if by user auditing. "ANY CLIENT" if access by a proxy on behalf of any client is being audited. NULL system wide auditing is being done
USER_NAME (DBA_REPCAT_TEMPLATE_SITES) Database user name.
USER_NAME (DBA_REPCAT_USER_PARM_VALUES) Database user name.
USER_NAME (ALL_REPCAT_USER_AUTHORIZATIONS) Database user name.
USER_NAME (USER_REPCAT_USER_PARM_VALUES) Database user name.
USER_NAME (DBA_PRIV_AUDIT_OPTS) User name if by user auditing. "ANY CLIENT" if access by a proxy on behalf of any client is being audited. NULL system wide auditing is being done
USER_NAME (DBA_REPCAT_USER_AUTHORIZATIONS) Database user name.
USER_NAME (ALL_LOB_TEMPLATES)
USER_NAME (USER_REPCAT_USER_AUTHORIZATION) Database user name.
USER_NAME (ALL_REPCAT_TEMPLATE_SITES) Database user name.
USER_NAME (DBA_LOB_TEMPLATES)
USER_OVERRIDE (ALL_REPCAT_TEMPLATE_PARMS) User override flag.
USER_OVERRIDE (DBA_REPCAT_TEMPLATE_PARMS) User override flag.
USER_OVERRIDE (USER_REPCAT_TEMPLATE_PARMS) User override flag.
USER_PROCEDURE (DBA_APPLY_DML_HANDLERS) Name of the DML handler specified by the user
USER_PROCEDURE (ALL_APPLY_DML_HANDLERS) Name of the DML handler specified by the user
USER_STATS (USER_INDEXES) Were the statistics entered directly by the user?
USER_STATS (ALL_ALL_TABLES) Were the statistics entered directly by the user?
USER_STATS (ALL_TAB_PARTITIONS)
USER_STATS (DBA_TAB_COL_STATISTICS) Were the statistics entered directly by the user?
USER_STATS (DBA_TAB_COLUMNS) Were the statistics entered directly by the user?
USER_STATS (USER_TABLES) Were the statistics entered directly by the user?
USER_STATS (ALL_SUBPART_COL_STATISTICS)
USER_STATS (USER_TAB_PARTITIONS)
USER_STATS (IND) Were the statistics entered directly by the user?
USER_STATS (ALL_IND_SUBPARTITIONS)
USER_STATS (TABS) Were the statistics entered directly by the user?
USER_STATS (DBA_TABLES) Were the statistics entered directly by the user?
USER_STATS (DBA_OBJECT_TABLES) Were the statistics entered directly by the user?
USER_STATS (USER_OBJECT_TABLES) Were the statistics entered directly by the user?
USER_STATS (ALL_INDEXES) Were the statistics entered directly by the user?
USER_STATS (DBA_TAB_SUBPARTITIONS)
USER_STATS (USER_IND_SUBPARTITIONS)
USER_STATS (USER_PART_COL_STATISTICS)
USER_STATS (USER_IND_PARTITIONS)
USER_STATS (DBA_INDEXES) Were the statistics entered directly by the user?
USER_STATS (ALL_PART_COL_STATISTICS)
USER_STATS (USER_TAB_SUBPARTITIONS)
USER_STATS (ALL_OBJECT_TABLES) Were the statistics entered directly by the user?
USER_STATS (DBA_TAB_COLS) Were the statistics entered directly by the user?
USER_STATS (DBA_IND_PARTITIONS)
USER_STATS (DBA_TAB_PARTITIONS)
USER_STATS (ALL_IND_PARTITIONS)
USER_STATS (USER_TAB_COLUMNS) Were the statistics entered directly by the user?
USER_STATS (DBA_IND_SUBPARTITIONS)
USER_STATS (DBA_ALL_TABLES) Were the statistics entered directly by the user?
USER_STATS (ALL_TABLES) Were the statistics entered directly by the user?
USER_STATS (ALL_TAB_COLS) Were the statistics entered directly by the user?
USER_STATS (DBA_SUBPART_COL_STATISTICS)
USER_STATS (COLS) Were the statistics entered directly by the user?
USER_STATS (USER_SUBPART_COL_STATISTICS)
USER_STATS (ALL_TAB_COLUMNS) Were the statistics entered directly by the user?
USER_STATS (USER_ALL_TABLES) Were the statistics entered directly by the user?
USER_STATS (ALL_TAB_SUBPARTITIONS)
USER_STATS (USER_TAB_COL_STATISTICS) Were the statistics entered directly by the user?
USER_STATS (ALL_TAB_COL_STATISTICS) Were the statistics entered directly by the user?
USER_STATS (USER_TAB_COLS) Were the statistics entered directly by the user?
USER_STATS (DBA_PART_COL_STATISTICS)
top back to index

Comment on this page:




home - keyword index