-
Title
I need a list of all the tables and views that the Schema Browser accesses.< -
Description
Is there a list of all the tables and views that the Schema Browser accesses? I need to be able to view all areas in the Schema Browser including other users or schemas objects.
-
Resolution
Per the Development Team, there is no such a list because the Schema Browser can access everything in a schema (with the appropriate privileges). The Schema Browser pretty much accesses all the DBA_, USER_, and ALL_ views.
See the list below for the things that Toad for Oracle is most likely to use, but there may be exceptions. This list is also not just limited to the Schema Browser. It has ALL_, DBA_, and USER_ views, the user does not need access to the DBA_ ones.
NOTE: If a user will be updating objects owned by another user, a DBA will need to give privileges to that user i.e. run "GRANT ALL ON other_user_name.object_name TO your_user_name;" script (or change the script to only grant i.e. UPDATE, ALTER, INSERT, etc) for "each of the objects" owned by the other user.
If the DBA uses Toad, that person can go to Database Menu | Administer | Multiple Object Privileges. This feature is very useful when granting (grantor) multiple objects to one or more grantees.
In addition, utilize SQL Monitor as well (Database | Monitor | SQL Monitor) for a quick view of the SQL statements that Toad sent in the background for an action / activity that was done in Toad.
NOTE: Granting the objects below to a user will only give "view" access to other user's objects; the user will still not be able to do any editing or updates (see other NOTE above):
ALL_ALL_TABLES
ALL_CLUSTER_HASH_EXPRESSIONS
ALL_CLUSTERS
ALL_COL_COMMENTS
ALL_COL_PRIVS
ALL_CONS_COLUMNS
ALL_CONSTRAINTS
ALL_CONTEXT
ALL_DB_LINKS
ALL_DEPENDENCIES
ALL_DIM_ATTRIBUTES
ALL_DIM_CHILD_OF
ALL_DIM_HIERARCHIES
ALL_DIM_JOIN_KEY
ALL_DIM_LEVEL_KEY
ALL_DIM_LEVELS
ALL_DIMENSIONS
ALL_DIRECTORIES
ALL_ENCRYPTED_COLUMNS
ALL_ERRORS
ALL_EXTERNAL_LOCATIONS
ALL_EXTERNAL_TABLES
ALL_IND_COLUMNS
ALL_IND_EXPRESSIONS
ALL_IND_PARTITIONS
ALL_IND_SUBPARTITIONS
ALL_INDEXES
ALL_INDEXTYPES
ALL_JOBS
ALL_JOIN_IND_COLUMNS
ALL_LIBRARIES
ALL_LOB_PARTITIONS
ALL_LOB_SUBPARTITIONS
ALL_LOBS
ALL_LOG_GROUP_COLUMNS
ALL_LOG_GROUPS
ALL_MVIEWS
ALL_MVIEW_COMMENTS
ALL_NESTED_TABLES
ALL_OBJ_COLATTRS
ALL_OBJECT_TABLES
ALL_OBJECTS
ALL_OUTLINES
ALL_PART_COL_STATISTICS
ALL_PART_INDEXES
ALL_PART_KEY_COLUMNS
ALL_PART_TABLES
ALL_POLICIES
ALL_POLICY_GROUPS
ALL_PROCEDURES
ALL_QUEUE_TABLES
ALL_QUEUES
ALL_QUEUE_SCHEDULES
ALL_RECYCLEBIN
ALL_REFRESH
ALL_REFRESH_CHILDREN
ALL_REFS
ALL_REGISTERED_SNAPSHOTS
ALL_RULE_SETS
ALL_RULES
ALL_RSRC_PLANS
ALL_RSRC_CONSUMER_GROUPS
ALL_SCHEDULER_CHAIN_STEPS
ALL_SCHEDULER_CHAIN_RULES
ALL_SCHEDULER_CHAINS
ALL_SCHEDULER_RUNNING_CHAINS
ALL_SCHEDULER_RUNNING_JOBS
ALL_SCHEDULER_JOBS
ALL_SCHEDULER_JOB_ARGS
ALL_SCHEDULER_JOB_CLASSES
ALL_SCHEDULER_PROGRAMS
ALL_SCHEDULER_PROGRAM_ARGS
ALL_SCHEDULER_SCHEDULES
ALL_SCHEDULER_WINDOWS
ALL_SCHEDULER_WINDOW_GROUPS
ALL_SCHEDULER_WINGROUP_MEMBERS
ALL_SCHEDULER_JOB_LOG
ALL_SCHEDULER_JOB_RUN_DETAILS
ALL_SCHEDULER_WINDOW_LOG
ALL_SCHEDULER_WINDOW_DETAILS
ALL_SEC_RELEVANT_COLS
ALL_SEQUENCES
ALL_SNAPSHOT_LOGS
ALL_SNAPSHOTS
ALL_SOURCE
ALL_SUBPART_COL_STATISTICS
ALL_SUBPART_KEY_COLUMNS
ALL_SUBPARTITION_TEMPLATES
ALL_SYNONYMS
ALL_TAB_COLS
ALL_TAB_COLUMNS
ALL_TAB_COMMENTS
ALL_TAB_PARTITIONS
ALL_TAB_PRIVS
ALL_TAB_SUBPARTITIONS
ALL_TABLES
ALL_TRIGGER_COLS
ALL_TRIGGERS
ALL_TRANSFORMATIONS
ALL_TYPE_ATTRS
ALL_TYPE_METHODS
ALL_TYPES
ALL_UPDATABLE_COLUMNS
ALL_USERS
ALL_VIEWS
ALL_XML_SCHEMAS
ALL_XML_TAB_COLS
ALL_XML_TABLES
ALL_XML_VIEWS
DBA_ADVISOR_FINDINGS
DBA_ADVISOR_RECOMMENDATIONS
DBA_ADVISOR_TASKS
DBA_ADVISOR_LOG
DBA_ADVISOR_JOURNAL
DBA_ADVISOR_ACTIONS
DBA_ADVISOR_PARAMETERS
DBA_ADVISOR_SQLA_WK_STMTS
DBA_ADVISOR_SQLA_WK_MAP
DBA_ADVISOR_SQLW_SUM
DBA_ADVISOR_SQLW_STMTS
DBA_ADVISOR_SQLW_PARAMETERS
DBA_ADVISOR_SQLW_JOURNAL
DBA_ADVISOR_SQLW_TEMPLATES
DBA_ALL_TABLES
DBA_CLUSTER_HASH_EXPRESSIONS
DBA_CLUSTERS
DBA_COL_COMMENTS
DBA_COL_PRIVS
DBA_CONS_COLUMNS
DBA_CONSTRAINTS
DBA_CONTEXT
DBA_CLU_COLUMNS
DBA_DB_LINKS
DBA_DEPENDENCIES
DBA_DIM_ATTRIBUTES
DBA_DIM_CHILD_OF
DBA_DIM_HIERARCHIES
DBA_DIM_JOIN_KEY
DBA_DIM_LEVEL_KEY
DBA_DIM_LEVELS
DBA_DIMENSIONS
DBA_DIRECTORIES
DBA_ENCRYPTED_COLUMNS
DBA_ERRORS
DBA_EXTENTS
DBA_EXTERNAL_LOCATIONS
DBA_EXTERNAL_TABLES
DBA_FLASHBACK_ARCHIVE
DBA_FLASHBACK_ARCHIVE_TABLES
DBA_FLASHBACK_ARCHIVE_TS
DBA_IND_COLUMNS
DBA_IND_EXPRESSIONS
DBA_IND_PARTITIONS
DBA_IND_SUBPARTITIONS
DBA_INDEXES
DBA_INDEXTYPES
DBA_JAVA_POLICY
DBA_JOBS
DBA_JOIN_IND_COLUMNS
DBA_LIBRARIES
DBA_LOB_PARTITIONS
DBA_LOB_SUBPARTITIONS
DBA_LOBS
DBA_LOG_GROUP_COLUMNS
DBA_LOG_GROUPS
DBA_MVIEWS
DBA_MVIEW_COMMENTS
DBA_NESTED_TABLES
DBA_OBJ_COLATTRS
DBA_OBJECT_TABLES
DBA_OBJECTS
DBA_OUTLINES
DBA_PART_COL_STATISTICS
DBA_PART_INDEXES
DBA_PART_KEY_COLUMNS
DBA_PART_TABLES
DBA_POLICIES
DBA_POLICY_GROUPS
DBA_PROFILES
DBA_PROCEDURES
DBA_PROXIES
DBA_QUEUE_TABLES
DBA_QUEUES
DBA_QUEUE_SCHEDULES
DBA_RECYCLEBIN
DBA_REFRESH
DBA_REFRESH_CHILDREN
DBA_REFS
DBA_REGISTERED_SNAPSHOTS
DBA_ROLLBACK_SEGS
DBA_ROLES
DBA_ROLE_PRIVS
DBA_RULE_SETS
DBA_RULES
DBA_RSRC_CONSUMER_GROUPS
DBA_RSRC_CONSUMER_GROUP_PRIVS
DBA_RSRC_PLANS
DBA_SCHEDULER_CHAIN_STEPS
DBA_SCHEDULER_CHAIN_RULES
DBA_SCHEDULER_CHAINS
DBA_SCHEDULER_RUNNING_CHAINS
DBA_SCHEDULER_RUNNING_JOBS
DBA_SCHEDULER_JOBS
DBA_SCHEDULER_JOB_ARGS
DBA_SCHEDULER_JOB_CLASSES
DBA_SCHEDULER_PROGRAMS
DBA_SCHEDULER_PROGRAM_ARGS
DBA_SCHEDULER_SCHEDULES
DBA_SCHEDULER_WINDOWS
DBA_SCHEDULER_WINDOW_GROUPS
DBA_SCHEDULER_WINGROUP_MEMBERS
DBA_SCHEDULER_JOB_LOG
DBA_SCHEDULER_JOB_RUN_DETAILS
DBA_SCHEDULER_WINDOW_LOG
DBA_SCHEDULER_WINDOW_DETAILS
DBA_SEC_RELEVANT_COLS
DBA_SEGMENTS
DBA_SEQUENCES
DBA_SNAPSHOT_LOGS
DBA_SNAPSHOTS
DBA_SOURCE
DBA_SQL_PROFILES
DBA_SUBPART_COL_STATISTICS
DBA_SUBPART_KEY_COLUMNS
DBA_SUBPARTITION_TEMPLATES
DBA_SUBPARTITION_TEMPLATES
DBA_SYNONYMS
DBA_SYS_PRIVS
DBA_TAB_COLS
DBA_TAB_COLUMNS
DBA_TAB_COMMENTS
DBA_TAB_PARTITIONS
DBA_TAB_PRIVS
DBA_TAB_SUBPARTITIONS
DBA_TABLES
DBA_TABLESPACES
DBA_TRIGGER_COLS
DBA_TRIGGERS
DBA_TRANSFORMATIONS
DBA_TS_QUOTAS
DBA_TYPE_ATTRS
DBA_TYPE_METHODS
DBA_TYPES
ALL_UPDATABLE_COLUMNS
DBA_USERS
DBA_VIEWS
DBA_XML_SCHEMAS
DBA_XML_TAB_COLS
DBA_XML_TABLES
DBA_XML_VIEWS
USER_IND_PARTITIONS
USER_IND_SUBPARTITIONS
USER_PART_KEY_COLUMNS
USER_SUBPART_KEY_COLUMNS
USER_TAB_PARTITIONS
USER_TAB_SUBPARTITIONS
USER_TABLESPACES