Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: What rights/role or SQL used for 'Explore'

  1. #1
    Join Date
    Mar 2006
    Posts
    16

    Default What rights/role or SQL used for 'Explore'

    When I hit the Explore button on the Connection Information screen it just locks up on 'Getting Schema Information' - I can connect OK - I am connecting to an Oracle 9i database - release 9.2.0.6.0 64 bit in HP-UX. I am suspecting a role or privelege problem as I have used a table in the database as an input with no problems, but I'd like to use one as an output - specifically an update, now but I can't retrieve the columns and I suspect both problems are related. Thanks.

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default RE: What rights/role or SQL used for 'Explore'

    Hi Stu,

    It should never "lock up" at all. I would consider that a bug.
    The thing that's probably happening is that the database explorer gets all the tables, views etc. from the complete database. In case you have something big in one of the schema's (let's say SAP) you might have problem in getting the info over to Kettle fast enough.
    I intend to solve this in the future by building intelligent Tree views that will query the database when you open a sub-tree. In the new SWT "Tree" widget you can embed graphics that can show progress-bars etc ;-)

    As for the rest: to minimize the user-rights problems this is the query that gets executed (for Oracle) to retrieve the fields that are in a certain table:

    SELECT /*+FIRST_ROWS*/ * FROM tableName WHERE ROWNUM < 1

    The data dictionary lookups to populate the DB explorer are done through the standard JDBC meta-data. I guess that you would need at least read access to views user_tables, user_tab_columns etc.

    Hope this helps,

    Matt

  3. #3
    Join Date
    Mar 2006
    Posts
    16

    Default RE: What rights/role or SQL used for 'Explore'

    It's been stuck on the 'Getting schema information' with the bars a little less than half-way up for about 20 minutes, now - if I hit cancel - nothing happens - I end up having to give her the old 3 finger salute and knock Spoon out via the task manager. This Oracle database is small which led me to suspect a role issue - I've been using this feature against DB2 databases with no problems - plus the fact that I can use the SQL Editor against this Oracle database and query tables to my hearts desire. Hmmmm....

  4. #4
    Join Date
    Mar 2006
    Posts
    16

    Default RE: What rights/role or SQL used for 'Explore'

    Here's the views I have SELECT on


    ALL_ALL_TABLES
    ALL_APPLY
    ALL_APPLY_CONFLICT_COLUMNS
    ALL_APPLY_DML_HANDLERS
    ALL_APPLY_ERROR
    ALL_APPLY_KEY_COLUMNS
    ALL_APPLY_PARAMETERS
    ALL_APPLY_PROGRESS
    ALL_ARGUMENTS
    ALL_ASSOCIATIONS
    ALL_BASE_TABLE_MVIEWS
    ALL_CAPTURE
    ALL_CAPTURE_PARAMETERS
    ALL_CAPTURE_PREPARED_DATABASE
    ALL_CAPTURE_PREPARED_SCHEMAS
    ALL_CAPTURE_PREPARED_TABLES
    ALL_CATALOG
    ALL_CLUSTERS
    ALL_CLUSTER_HASH_EXPRESSIONS
    ALL_COLL_TYPES
    ALL_COL_COMMENTS
    ALL_COL_PRIVS
    ALL_COL_PRIVS_MADE
    ALL_COL_PRIVS_RECD
    ALL_CONSTRAINTS
    ALL_CONS_COLUMNS
    ALL_CONS_OBJ_COLUMNS
    ALL_CONTEXT
    ALL_DB_LINKS
    ALL_DEF_AUDIT_OPTS
    ALL_DEPENDENCIES
    ALL_DIMENSIONS
    ALL_DIM_ATTRIBUTES
    ALL_DIM_CHILD_OF
    ALL_DIM_HIERARCHIES
    ALL_DIM_JOIN_KEY
    ALL_DIM_LEVELS
    ALL_DIM_LEVEL_KEY
    ALL_DIRECTORIES
    ALL_ERRORS
    ALL_EVALUATION_CONTEXTS
    ALL_EVALUATION_CONTEXT_TABLES
    ALL_EVALUATION_CONTEXT_VARS
    ALL_EXTERNAL_LOCATIONS
    ALL_EXTERNAL_TABLES
    ALL_GEOMETRY_COLUMNS
    ALL_INDEXES
    ALL_INDEXTYPES
    ALL_INDEXTYPE_OPERATORS
    ALL_IND_COLUMNS
    ALL_IND_EXPRESSIONS
    ALL_IND_PARTITIONS
    ALL_IND_SUBPARTITIONS
    ALL_INTERNAL_TRIGGERS
    ALL_JAVA_ARGUMENTS
    ALL_JAVA_CLASSES
    ALL_JAVA_DERIVATIONS
    ALL_JAVA_FIELDS
    ALL_JAVA_IMPLEMENTS
    ALL_JAVA_INNERS
    ALL_JAVA_LAYOUTS
    ALL_JAVA_METHODS
    ALL_JAVA_NCOMPS
    ALL_JAVA_RESOLVERS
    ALL_JAVA_THROWS
    ALL_JOIN_IND_COLUMNS
    ALL_LIBRARIES
    ALL_LOBS
    ALL_LOB_PARTITIONS
    ALL_LOB_SUBPARTITIONS
    ALL_LOB_TEMPLATES
    ALL_LOG_GROUPS
    ALL_LOG_GROUP_COLUMNS
    ALL_METHOD_PARAMS
    ALL_METHOD_RESULTS
    ALL_MVIEWS
    ALL_MVIEW_AGGREGATES
    ALL_MVIEW_ANALYSIS
    ALL_MVIEW_DETAIL_RELATIONS
    ALL_MVIEW_JOINS
    ALL_MVIEW_KEYS
    ALL_MVIEW_LOGS
    ALL_MVIEW_REFRESH_TIMES
    ALL_NESTED_TABLES
    ALL_OBJECTS
    ALL_OBJECT_TABLES
    ALL_OBJ_COLATTRS
    ALL_OPANCILLARY
    ALL_OPARGUMENTS
    ALL_OPBINDINGS
    ALL_OPERATORS
    ALL_PARTIAL_DROP_TABS
    ALL_PART_COL_STATISTICS
    ALL_PART_HISTOGRAMS
    ALL_PART_INDEXES
    ALL_PART_KEY_COLUMNS
    ALL_PART_LOBS
    ALL_PART_TABLES
    ALL_PENDING_CONV_TABLES
    ALL_POLICIES
    ALL_POLICY_CONTEXTS
    ALL_POLICY_GROUPS
    ALL_PROBE_OBJECTS
    ALL_PROCEDURES
    ALL_PROPAGATION
    ALL_PUBLISHED_COLUMNS
    ALL_QUEUES
    ALL_QUEUE_PUBLISHERS
    ALL_QUEUE_TABLES
    ALL_REFRESH
    ALL_REFRESH_CHILDREN
    ALL_REFRESH_DEPENDENCIES
    ALL_REFS
    ALL_REGISTERED_MVIEWS
    ALL_REGISTERED_SNAPSHOTS
    ALL_REGISTRY_BANNERS
    ALL_REPAUDIT_ATTRIBUTE
    ALL_REPAUDIT_COLUMN
    ALL_REPCAT
    ALL_REPCATLOG
    ALL_REPCAT_REFRESH_TEMPLATES
    ALL_REPCAT_TEMPLATE_OBJECTS
    ALL_REPCAT_TEMPLATE_PARMS
    ALL_REPCAT_TEMPLATE_SITES
    ALL_REPCAT_USER_AUTHORIZATIONS
    ALL_REPCAT_USER_PARM_VALUES
    ALL_REPCOLUMN
    ALL_REPCOLUMN_GROUP
    ALL_REPCONFLICT
    ALL_REPDDL
    ALL_REPFLAVORS
    ALL_REPFLAVOR_COLUMNS
    ALL_REPFLAVOR_OBJECTS
    ALL_REPGENERATED
    ALL_REPGENOBJECTS
    ALL_REPGROUP
    ALL_REPGROUPED_COLUMN
    ALL_REPGROUP_PRIVILEGES
    ALL_REPKEY_COLUMNS
    ALL_REPOBJECT
    ALL_REPPARAMETER_COLUMN
    ALL_REPPRIORITY
    ALL_REPPRIORITY_GROUP
    ALL_REPPROP
    ALL_REPRESOLUTION
    ALL_REPRESOLUTION_METHOD
    ALL_REPRESOLUTION_STATISTICS
    ALL_REPRESOL_STATS_CONTROL
    ALL_REPSCHEMA
    ALL_REPSITES
    ALL_RULES
    ALL_RULESETS
    ALL_RULE_SETS
    ALL_RULE_SET_RULES
    ALL_SDO_GEOM_METADATA
    ALL_SDO_INDEX_INFO
    ALL_SDO_INDEX_METADATA
    ALL_SDO_LRS_METADATA
    ALL_SDO_MAPS
    ALL_SDO_STYLES
    ALL_SDO_THEMES
    ALL_SEQUENCES
    ALL_SNAPSHOTS
    ALL_SNAPSHOT_LOGS
    ALL_SOURCE
    ALL_SOURCE_TABLES
    ALL_SOURCE_TAB_COLUMNS
    ALL_SQLJ_TYPES
    ALL_SQLJ_TYPE_ATTRS
    ALL_SQLJ_TYPE_METHODS
    ALL_STORED_SETTINGS
    ALL_STREAMS_GLOBAL_RULES
    ALL_STREAMS_SCHEMA_RULES
    ALL_STREAMS_TABLE_RULES
    ALL_SUBPARTITION_TEMPLATES
    ALL_SUBPART_COL_STATISTICS
    ALL_SUBPART_HISTOGRAMS
    ALL_SUBPART_KEY_COLUMNS
    ALL_SUBSCRIBED_COLUMNS
    ALL_SUBSCRIBED_TABLES
    ALL_SUBSCRIPTIONS
    ALL_SUMDELTA
    ALL_SUMMARIES
    ALL_SUMMARY_AGGREGATES
    ALL_SUMMARY_DETAIL_TABLES
    ALL_SUMMARY_JOINS
    ALL_SUMMARY_KEYS
    ALL_SYNONYMS
    ALL_TABLES
    ALL_TAB_COLS
    ALL_TAB_COLUMNS
    ALL_TAB_COL_STATISTICS
    ALL_TAB_COMMENTS
    ALL_TAB_HISTOGRAMS
    ALL_TAB_MODIFICATIONS
    ALL_TAB_PARTITIONS
    ALL_TAB_PRIVS
    ALL_TAB_PRIVS_MADE
    ALL_TAB_PRIVS_RECD
    ALL_TAB_SUBPARTITIONS
    ALL_TRIGGERS
    ALL_TRIGGER_COLS
    ALL_TYPES
    ALL_TYPE_ATTRS
    ALL_TYPE_METHODS
    ALL_TYPE_VERSIONS
    ALL_UNUSED_COL_TABS
    ALL_UPDATABLE_COLUMNS
    ALL_USERS
    ALL_USTATS
    ALL_VARRAYS
    ALL_VERSION_HVIEW
    ALL_VIEWS
    ALL_WM_LOCKED_TABLES
    ALL_WM_MODIFIED_TABLES
    ALL_WM_RIC_INFO
    ALL_WM_TAB_TRIGGERS
    ALL_WM_VERSIONED_TABLES
    ALL_WM_VT_ERRORS
    ALL_WORKSPACES
    ALL_WORKSPACES_INTERNAL
    ALL_WORKSPACE_PRIVS
    ALL_WORKSPACE_SAVEPOINTS
    ALL_XML_SCHEMAS
    ALL_XML_TABLES
    ALL_XML_TAB_COLS
    ALL_XML_VIEWS
    ALL_XML_VIEW_COLS
    CATALOG
    CMISPB_ACTING_V
    CMISPB_AIS_CONTROL_NUMBERS_V
    CMISPB_AIS_RELEASE_V
    CMISPB_AIS_V
    CMISPB_ALL_CCO_V
    CMISPB_ALL_USER_UNAVAIL_V
    CMISPB_AM_RELATIONSHIPS_V
    CMISPB_CCO_VX
    CMISPB_CI_DELIVERY_V
    CMISPB_CI_DELIV_AND_TEST_V
    CMISPB_CI_DEPENDENCY_V
    CMISPB_CI_FUNCTION_POINT_DAT_V
    CMISPB_CI_ROLL_UP_V
    CMISPB_CI_TDR_V
    CMISPB_CI_TEST_V
    CMISPB_CI_TYPE_V
    CMISPB_CI_TYPE_VX
    CMISPB_CI_V
    CMISPB_CI_VX
    CMISPB_CMIS_USER_V
    CMISPB_CMIS_USER_VX
    CMISPB_FUNC_ACTING_V
    CMISPB_FUNC_AM_RELATION_V
    CMISPB_FUNC_CCO_V
    CMISPB_FUNC_CMIS_USER_V
    CMISPB_FUNC_MAIL_GROUP_V
    CMISPB_FUNC_USER_ACCESS_V
    CMISPB_FUNC_USER_UNAVAIL_V
    CMISPB_MAIL_GROUP_V
    CMISPB_MAIL_V
    CMISPB_PTR_DEF_V
    CMISPB_PTR_DEF_VX
    CMISPB_PTR_XREF_V
    CMISPB_RELEASE_AUDIT_V
    CMISPB_RELEASE_TDR_ROUTING_V
    CMISPB_RELEASE_TDR_SCR_CI_V
    CMISPB_RELEASE_TDR_V
    CMISPB_RELEASE_TEST_EVENT_V
    CMISPB_RELEASE_TEST_V
    CMISPB_REL_TESTS_AND_EVENTS_V
    CMISPB_SCR_APP_V
    CMISPB_SCR_ATTACHMENTS_V
    CMISPB_SCR_NOTES_V
    CMISPB_SCR_PTR_XREF_V
    CMISPB_SCR_TDR_CI_V
    CMISPB_SCR_TDR_ROUTING_V
    CMISPB_SCR_TDR_V
    CMISPB_SCR_TEST_AND_EVENTS_V
    CMISPB_SCR_TEST_EVENTS_V
    CMISPB_SCR_TEST_V
    CMISPB_SCR_TEXT_V
    CMISPB_SCR_V
    CMISPB_SCR_VX
    CMISPB_SCR_XREF_V
    CMISPB_TECH_ACTING_V
    CMISPB_TECH_AM_RELATION_V
    CMISPB_TECH_CCO_V
    CMISPB_TECH_CMIS_USER_V
    CMISPB_TECH_MAIL_GROUP_V
    CMISPB_TECH_USER_ACCESS_V
    CMISPB_TECH_USER_UNAVAIL_V
    CMISPB_USER_ACCESS_V
    CMISPB_USER_SEC_VX
    COL
    COLUMN_PRIVILEGES
    CTX_CLASSES
    CTX_INDEX_SETS
    CTX_INDEX_SET_INDEXES
    CTX_OBJECTS
    CTX_OBJECT_ATTRIBUTES
    CTX_OBJECT_ATTRIBUTE_LOV
    CTX_PARAMETERS
    CTX_PREFERENCES
    CTX_PREFERENCE_VALUES
    CTX_SECTIONS
    CTX_SECTION_GROUPS
    CTX_SQES
    CTX_STOPLISTS
    CTX_STOPWORDS
    CTX_SUB_LEXERS
    CTX_THESAURI
    CTX_THES_PHRASES
    CTX_USER_INDEXES
    CTX_USER_INDEX_ERRORS
    CTX_USER_INDEX_OBJECTS
    CTX_USER_INDEX_PARTITIONS
    CTX_USER_INDEX_SETS
    CTX_USER_INDEX_SET_INDEXES
    CTX_USER_INDEX_SUB_LEXERS
    CTX_USER_INDEX_SUB_LEXER_VALS
    CTX_USER_INDEX_VALUES
    CTX_USER_PENDING
    CTX_USER_PREFERENCES
    CTX_USER_PREFERENCE_VALUES
    CTX_USER_SECTIONS
    CTX_USER_SECTION_GROUPS
    CTX_USER_SQES
    CTX_USER_STOPLISTS
    CTX_USER_STOPWORDS
    CTX_USER_SUB_LEXERS
    CTX_USER_THESAURI
    CTX_USER_THES_PHRASES
    DATABASE_COMPATIBLE_LEVEL
    DATABASE_PROPERTIES
    DBA_PROCEDURES
    DBA_PUBLISHED_COLUMNS
    DBA_SDO_INDEX_INFO
    DBA_SDO_INDEX_METADATA
    DBA_SDO_LRS_METADATA
    DBA_SDO_MAPS
    DBA_SDO_STYLES
    DBA_SDO_THEMES
    DBA_SOURCE_TABLES
    DEFERRCOUNT
    DICTIONARY
    DICT_COLUMNS
    EXPCOMPRESSEDPART
    EXPCOMPRESSEDSUB
    EXPCOMPRESSEDTAB
    EXPTABSUBPART
    EXPTABSUBPARTDATA_VIEW
    EXPTABSUBPARTLOBFRAG
    EXPTABSUBPARTLOB_VIEW
    EXU7ANAL
    EXU7BSZ
    EXU7CCLO
    EXU7CCLU
    EXU7CCOU
    EXU7CGRU
    EXU7CLUU
    EXU7COLU
    EXU7CONU
    EXU7CPO
    EXU7CSET
    EXU7FUL
    EXU7GRNU
    EXU7ICOU
    EXU7INDU
    EXU7JBQU
    EXU7LNKU
    EXU7ORD
    EXU7ORDU
    EXU7PSTU
    EXU7REFU
    EXU7RGCU
    EXU7RGSU
    EXU7SEQU
    EXU7SNAPLU
    EXU7SNAPU
    EXU7SPSU
    EXU7SPU
    EXU7STOU
    EXU7SYNU
    EXU7TABU
    EXU7TGRU
    EXU7TNE
    EXU7USCU
    EXU7USRU
    EXU7VER
    EXU7VEWU
    EXU816MAXSQV
    EXU816TGRU
    EXU81ACTIONOBJ
    EXU81ACTIONPKG
    EXU81ASSOC
    EXU81CSC
    EXU81DOIU
    EXU81IND
    EXU81ITYU
    EXU81IXCPU
    EXU81IXSPU
    EXU81JAV
    EXU81JAVT
    EXU81LBCPU
    EXU81LBPU
    EXU81LBSPU
    EXU81NOS
    EXU81OBJECTPKG
    EXU81OPRU
    EXU81PLBU
    EXU81PROCOBJ
    EXU81PROCOBJINSTANCE
    EXU81RGCU
    EXU81RGSU
    EXU81RLS
    EXU81SCMU
    EXU81SLFCU
    EXU81SNAPLU
    EXU81SNAPU
    EXU81SPOKIU
    EXU81SPOKU
    EXU81SRTU
    EXU81TABSU
    EXU81TABU
    EXU81TBCPU
    EXU81TBSPU
    EXU81TGRU
    EXU81TYPU
    EXU81USCIU
    EXU8ANAL
    EXU8ASCU
    EXU8BSZ
    EXU8CCLO
    EXU8CCLU
    EXU8CCOU
    EXU8CGRU
    EXU8CLUU
    EXU8CMTU
    EXU8COEU
    EXU8COLU
    EXU8CONU
    EXU8COOU
    EXU8CPO
    EXU8CSET
    EXU8CSNU
    EXU8DIM
    EXU8DIMU
    EXU8FPTU
    EXU8FUL
    EXU8GLOB
    EXU8GRNU
    EXU8HSTU
    EXU8ICO
    EXU8ICOU
    EXU8ICPLSQL
    EXU8INDU
    EXU8INKU
    EXU8IOVU
    EXU8IXPU
    EXU8JBQU
    EXU8LIBU
    EXU8LNKU
    EXU8LOBU
    EXU8NTBU
    EXU8NXPU
    EXU8OIDU
    EXU8OPT
    EXU8ORD
    EXU8ORDU
    EXU8ORFS
    EXU8PDSU
    EXU8PNTU
    EXU8POKIU
    EXU8POKU
    EXU8PSTU
    EXU8REFU
    EXU8RFSU
    EXU8RGCU
    EXU8RGSU
    EXU8SCMU
    EXU8SEQU
    EXU8SLFCU
    EXU8SLOGU
    EXU8SNAPLU
    EXU8SNAPU
    EXU8SPSU
    EXU8SPU
    EXU8SRTU
    EXU8STOU
    EXU8SYNU
    EXU8TABU
    EXU8TBPU
    EXU8TGRU
    EXU8TNE
    EXU8TNEB
    EXU8TYPBU
    EXU8TYPTU
    EXU8TYPU
    EXU8USCU
    EXU8USRU
    EXU8VDPTU
    EXU8VER
    EXU8VEWU
    EXU8VINFU
    EXU8VNCU
    EXU92FPTPU
    EXU92FPTU
    EXU92TGRU
    EXU92TSP
    EXU92TSPL
    EXU9ACTIONOBJ
    EXU9BJF
    EXU9BJW
    EXU9CCLO
    EXU9CCLU
    EXU9COEU
    EXU9COOU
    EXU9DEFPSWITCHES
    EXU9DOIU
    EXU9DOSO
    EXU9EIP
    EXU9FGA
    EXU9GSAS
    EXU9IND
    EXU9IND_BASE
    EXU9INHCOLCONS
    EXU9IXCPU
    EXU9LBCPU
    EXU9LBPU
    EXU9LNKU
    EXU9LOBU
    EXU9MVL
    EXU9MVLCDCCC
    EXU9MVLCDCS
    EXU9MVLCDCSC
    EXU9MVLCDCST
    EXU9NLS
    EXU9NOS
    EXU9OBJSWITCH
    EXU9OTNNULL
    EXU9PCT
    EXU9PDSU
    EXU9PGP
    EXU9PLBU
    EXU9PTS
    EXU9RLS
    EXU9SNAPLU
    EXU9SNAPU
    EXU9STOU
    EXU9SYNU
    EXU9TABSU
    EXU9TABU
    EXU9TAB_UNUSED_COLS
    EXU9TBCPU
    EXU9TNE
    EXU9TNEB
    EXU9TYPTU
    EXU9TYPTU2
    EXU9TYPU
    EXU9UTSU
    EXU9XDBUID
    EXU9XMLST
    EXU9XTB
    GEODETIC_SRIDS
    GLOBAL_CONTEXT
    GLOBAL_NAME
    GV_$ACTIVE_INSTANCES
    GV_$ACTIVE_SESS_POOL_MTH
    GV_$AW_CALC
    GV_$AW_OLAP
    GV_$AW_SESSION_INFO
    GV_$BH
    GV_$LOADISTAT
    GV_$LOADPSTAT
    GV_$LOCK_ACTIVITY
    GV_$MAX_ACTIVE_SESS_TARGET_MTH
    GV_$MLS_PARAMETERS
    GV_$NLS_PARAMETERS
    GV_$NLS_VALID_VALUES
    GV_$OPTION
    GV_$PARALLEL_DEGREE_LIMIT_MTH
    GV_$PQ_SESSTAT
    GV_$PQ_TQSTAT
    GV_$QUEUEING_MTH
    GV_$RSRC_CONSUMER_GROUP
    GV_$RSRC_CONSUME_GROUP_CPU_MTH
    GV_$RSRC_PLAN
    GV_$RSRC_PLAN_CPU_MTH
    GV_$SESSION_LONGOPS
    GV_$TEMPORARY_LOBS
    GV_$TIMEZONE_NAMES
    GV_$VERSION
    IMP7UEC
    IMP8CDTU
    IMP8REPCAT
    IMP8TTDU
    IMP8UEC
    IMP9COMPAT
    IMP9SYN4
    IMP9TVOID
    IMP9USR
    INDEX_HISTOGRAM
    INDEX_STATS
    JAVASNM
    KU$_ASSOC_VIEW
    KU$_AUDIT_OBJ_VIEW
    KU$_AUDIT_VIEW
    KU$_CLUSTER_VIEW
    KU$_COMMENT_VIEW
    KU$_CONSTRAINT_VIEW
    KU$_CONTEXT_VIEW
    KU$_DBLINK_VIEW
    KU$_DEFROLE_VIEW
    KU$_DIMENSION_VIEW
    KU$_DIRECTORY_VIEW
    KU$_DOMIDX_PLSQL_VIEW
    KU$_EXTTAB_VIEW
    KU$_FGA_POLICY_VIEW
    KU$_FHTABLE_VIEW
    KU$_FULL_PKG_VIEW
    KU$_FULL_TYPE_VIEW
    KU$_FUNC_VIEW
    KU$_HTABLE_VIEW
    KU$_INDEXTYPE_VIEW
    KU$_INDEX_VIEW
    KU$_IOTABLE_VIEW
    KU$_JAVA_SOURCE_VIEW
    KU$_JOB_VIEW
    KU$_LIBRARY_VIEW
    KU$_M_VIEW_FH_VIEW
    KU$_M_VIEW_H_VIEW
    KU$_M_VIEW_IOT_VIEW
    KU$_M_VIEW_LOG_FH_VIEW
    KU$_M_VIEW_LOG_H_VIEW
    KU$_M_VIEW_LOG_PFH_VIEW
    KU$_M_VIEW_LOG_PH_VIEW
    KU$_M_VIEW_PFH_VIEW
    KU$_M_VIEW_PH_VIEW
    KU$_M_VIEW_PIOT_VIEW
    KU$_M_VIEW_VIEW
    KU$_OBJGRANT_VIEW
    KU$_OPERATOR_VIEW
    KU$_OUTLINE_VIEW
    KU$_PFHTABLE_VIEW
    KU$_PHTABLE_VIEW
    KU$_PIOTABLE_VIEW
    KU$_PKGBDY_VIEW
    KU$_PKG_VIEW
    KU$_PROC_VIEW
    KU$_PROFILE_VIEW
    KU$_PROXY_VIEW
    KU$_QTRANS_VIEW
    KU$_QUEUES_VIEW
    KU$_QUEUE_TABLE_VIEW
    KU$_REF_CONSTRAINT_VIEW
    KU$_RLS_CONTEXT_VIEW
    KU$_RLS_GROUP_VIEW
    KU$_RLS_POLICY_VIEW
    KU$_ROGRANT_VIEW
    KU$_ROLE_VIEW
    KU$_ROLLBACK_VIEW
    KU$_SEQUENCE_VIEW
    KU$_SYNONYM_VIEW
    KU$_SYSGRANT_VIEW
    KU$_TABLESPACE_VIEW
    KU$_TAB_TS_VIEW
    KU$_TRIGGER_VIEW
    KU$_TRLINK_VIEW
    KU$_TSQUOTA_VIEW
    KU$_TYPE_BODY_VIEW
    KU$_TYPE_VIEW
    KU$_USER_VIEW
    KU$_VIEW_VIEW
    KU$_XMLSCHEMA_VIEW
    LOADER_COL_INFO
    LOADER_CONSTRAINT_INFO
    LOADER_DIR_OBJS
    LOADER_FILE_TS
    LOADER_OID_INFO
    LOADER_PARAM_INFO
    LOADER_PART_INFO
    LOADER_REF_INFO
    LOADER_TAB_INFO
    LOADER_TRIGGER_INFO
    NLS_DATABASE_PARAMETERS
    NLS_INSTANCE_PARAMETERS
    NLS_SESSION_PARAMETERS
    ORA_KGLR7_DB_LINKS
    ORA_KGLR7_DEPENDENCIES
    ORA_KGLR7_IDL_CHAR
    ORA_KGLR7_IDL_SB4
    ORA_KGLR7_IDL_UB1
    ORA_KGLR7_IDL_UB2
    PATH_VIEW
    PRODUCT_COMPONENT_VERSION
    PRODUCT_PRIVS
    PUBLICSYN
    PUBLIC_DEPENDENCY
    QUEUE_PRIVILEGES
    RESOURCE_COST
    RESOURCE_VIEW
    ROLE_ROLE_PRIVS
    ROLE_SYS_PRIVS
    ROLE_TAB_PRIVS
    ROLE_WM_PRIVS
    SDO_RELATEMASK_TABLE
    SESSION_CONTEXT
    SESSION_PRIVS
    SESSION_ROLES
    SM_$VERSION
    SYNONYMS
    SYSCATALOG
    SYSFILES
    SYSSEGOBJ
    TAB
    TABLE_PRIVILEGES
    TABQUOTAS
    USER_ALL_TABLES
    USER_APPLICATION_ROLES
    USER_AQ_AGENT_PRIVS
    USER_ARGUMENTS
    USER_ASSOCIATIONS
    USER_ATTRIBUTE_TRANSFORMATIONS
    USER_AUDIT_OBJECT
    USER_AUDIT_SESSION
    USER_AUDIT_STATEMENT
    USER_AUDIT_TRAIL
    USER_AWS
    USER_AW_PS
    USER_BASE_TABLE_MVIEWS
    USER_CATALOG
    USER_CLUSTERS
    USER_CLUSTER_HASH_EXPRESSIONS
    USER_CLU_COLUMNS
    USER_COLL_TYPES
    USER_COL_COMMENTS
    USER_COL_PRIVS
    USER_COL_PRIVS_MADE
    USER_COL_PRIVS_RECD
    USER_CONSTRAINTS
    USER_CONS_COLUMNS
    USER_CONS_OBJ_COLUMNS
    USER_DB_LINKS
    USER_DEPENDENCIES
    USER_DIMENSIONS
    USER_DIM_ATTRIBUTES
    USER_DIM_CHILD_OF
    USER_DIM_HIERARCHIES
    USER_DIM_JOIN_KEY
    USER_DIM_LEVELS
    USER_DIM_LEVEL_KEY
    USER_ERRORS
    USER_EVALUATION_CONTEXTS
    USER_EVALUATION_CONTEXT_TABLES
    USER_EVALUATION_CONTEXT_VARS
    USER_EXTENTS
    USER_EXTERNAL_LOCATIONS
    USER_EXTERNAL_TABLES
    USER_FREE_SPACE
    USER_GEOMETRY_COLUMNS
    USER_INDEXES
    USER_INDEXTYPES
    USER_INDEXTYPE_OPERATORS
    USER_IND_COLUMNS
    USER_IND_EXPRESSIONS
    USER_IND_PARTITIONS
    USER_IND_SUBPARTITIONS
    USER_INTERNAL_TRIGGERS
    USER_JAVA_ARGUMENTS
    USER_JAVA_CLASSES
    USER_JAVA_DERIVATIONS
    USER_JAVA_FIELDS
    USER_JAVA_IMPLEMENTS
    USER_JAVA_INNERS
    USER_JAVA_LAYOUTS
    USER_JAVA_METHODS
    USER_JAVA_NCOMPS
    USER_JAVA_POLICY
    USER_JAVA_RESOLVERS
    USER_JAVA_THROWS
    USER_JOBS
    USER_JOIN_IND_COLUMNS
    USER_LIBRARIES
    USER_LOBS
    USER_LOB_PARTITIONS
    USER_LOB_SUBPARTITIONS
    USER_LOB_TEMPLATES
    USER_LOG_GROUPS
    USER_LOG_GROUP_COLUMNS
    USER_METHOD_PARAMS
    USER_METHOD_RESULTS
    USER_MVIEWS
    USER_MVIEW_AGGREGATES
    USER_MVIEW_ANALYSIS
    USER_MVIEW_DETAIL_RELATIONS
    USER_MVIEW_JOINS
    USER_MVIEW_KEYS
    USER_MVIEW_LOGS
    USER_MVIEW_REFRESH_TIMES
    USER_NESTED_TABLES
    USER_OBJECTS
    USER_OBJECT_SIZE
    USER_OBJECT_TABLES
    USER_OBJ_AUDIT_OPTS
    USER_OBJ_COLATTRS
    USER_OPANCILLARY
    USER_OPARGUMENTS
    USER_OPBINDINGS
    USER_OPERATORS
    USER_OUTLINES
    USER_OUTLINE_HINTS
    USER_PARTIAL_DROP_TABS
    USER_PART_COL_STATISTICS
    USER_PART_HISTOGRAMS
    USER_PART_INDEXES
    USER_PART_KEY_COLUMNS
    USER_PART_LOBS
    USER_PART_TABLES
    USER_PASSWORD_LIMITS
    USER_PENDING_CONV_TABLES
    USER_POLICIES
    USER_POLICY_CONTEXTS
    USER_POLICY_GROUPS
    USER_PROCEDURES
    USER_PROXIES
    USER_PUBLISHED_COLUMNS
    USER_QUEUES
    USER_QUEUE_PUBLISHERS
    USER_QUEUE_SCHEDULES
    USER_QUEUE_TABLES
    USER_REFRESH
    USER_REFRESH_CHILDREN
    USER_REFS
    USER_REGISTERED_MVIEWS
    USER_REGISTERED_SNAPSHOTS
    USER_REGISTRY
    USER_REPAUDIT_ATTRIBUTE
    USER_REPAUDIT_COLUMN
    USER_REPCAT
    USER_REPCATLOG
    USER_REPCAT_REFRESH_TEMPLATES
    USER_REPCAT_TEMPLATE_OBJECTS
    USER_REPCAT_TEMPLATE_PARMS
    USER_REPCAT_TEMPLATE_SITES
    USER_REPCAT_USER_AUTHORIZATION
    USER_REPCAT_USER_PARM_VALUES
    USER_REPCOLUMN
    USER_REPCOLUMN_GROUP
    USER_REPCONFLICT
    USER_REPDDL
    USER_REPFLAVORS
    USER_REPFLAVOR_COLUMNS
    USER_REPFLAVOR_OBJECTS
    USER_REPGENERATED
    USER_REPGENOBJECTS
    USER_REPGROUP
    USER_REPGROUPED_COLUMN
    USER_REPGROUP_PRIVILEGES
    USER_REPKEY_COLUMNS
    USER_REPOBJECT
    USER_REPPARAMETER_COLUMN
    USER_REPPRIORITY
    USER_REPPRIORITY_GROUP
    USER_REPPROP
    USER_REPRESOLUTION
    USER_REPRESOLUTION_METHOD
    USER_REPRESOLUTION_STATISTICS
    USER_REPRESOL_STATS_CONTROL
    USER_REPSCHEMA
    USER_REPSITES
    USER_RESOURCE_LIMITS
    USER_RESUMABLE
    USER_ROLE_PRIVS
    USER_RSRC_CONSUMER_GROUP_PRIVS
    USER_RSRC_MANAGER_SYSTEM_PRIVS
    USER_RULES
    USER_RULESETS
    USER_RULE_SETS
    USER_RULE_SET_RULES
    USER_SDO_GEOM_METADATA
    USER_SDO_INDEX_INFO
    USER_SDO_INDEX_METADATA
    USER_SDO_LRS_METADATA
    USER_SDO_MAPS
    USER_SDO_STYLES
    USER_SDO_THEMES
    USER_SEGMENTS
    USER_SEQUENCES
    USER_SNAPSHOTS
    USER_SNAPSHOT_LOGS
    USER_SOURCE
    USER_SOURCE_TABLES
    USER_SOURCE_TAB_COLUMNS
    USER_SQLJ_TYPES
    USER_SQLJ_TYPE_ATTRS
    USER_SQLJ_TYPE_METHODS
    USER_STORED_SETTINGS
    USER_SUBPARTITION_TEMPLATES
    USER_SUBPART_COL_STATISTICS
    USER_SUBPART_HISTOGRAMS
    USER_SUBPART_KEY_COLUMNS
    USER_SUBSCRIBED_COLUMNS
    USER_SUBSCRIBED_TABLES
    USER_SUBSCRIPTIONS
    USER_SUMMARIES
    USER_SUMMARY_AGGREGATES
    USER_SUMMARY_DETAIL_TABLES
    USER_SUMMARY_JOINS
    USER_SUMMARY_KEYS
    USER_SYNONYMS
    USER_SYS_PRIVS
    USER_TABLES
    USER_TABLESPACES
    USER_TAB_COLS
    USER_TAB_COLUMNS
    USER_TAB_COL_STATISTICS
    USER_TAB_COMMENTS
    USER_TAB_HISTOGRAMS
    USER_TAB_MODIFICATIONS
    USER_TAB_PARTITIONS
    USER_TAB_PRIVS
    USER_TAB_PRIVS_MADE
    USER_TAB_PRIVS_RECD
    USER_TAB_SUBPARTITIONS
    USER_TRANSFORMATIONS
    USER_TRIGGERS
    USER_TRIGGER_COLS
    USER_TS_QUOTAS
    USER_TYPES
    USER_TYPE_ATTRS
    USER_TYPE_METHODS
    USER_TYPE_VERSIONS
    USER_UNUSED_COL_TABS
    USER_UPDATABLE_COLUMNS
    USER_USERS
    USER_USTATS
    USER_VARRAYS
    USER_VIEWS
    USER_WM_LOCKED_TABLES
    USER_WM_MODIFIED_TABLES
    USER_WM_PRIVS
    USER_WM_RIC_INFO
    USER_WM_TAB_TRIGGERS
    USER_WM_VERSIONED_TABLES
    USER_WM_VT_ERRORS
    USER_WORKSPACES
    USER_WORKSPACE_PRIVS
    USER_WORKSPACE_SAVEPOINTS
    USER_XML_SCHEMAS
    USER_XML_TABLES
    USER_XML_TAB_COLS
    USER_XML_VIEWS
    USER_XML_VIEW_COLS
    V$OBJECT_USAGE
    V$OLAP_ALTER_SESSION
    V_$ACTIVE_INSTANCES
    V_$ACTIVE_SESS_POOL_MTH
    V_$AW_CALC
    V_$AW_OLAP
    V_$AW_SESSION_INFO
    V_$BH
    V_$DATABASE
    V_$LOADISTAT
    V_$LOADPSTAT
    V_$LOCK_ACTIVITY
    V_$MAX_ACTIVE_SESS_TARGET_MTH
    V_$MLS_PARAMETERS
    V_$NLS_PARAMETERS
    V_$NLS_VALID_VALUES
    V_$OPTION
    V_$PARALLEL_DEGREE_LIMIT_MTH
    V_$PQ_SESSTAT
    V_$PQ_TQSTAT
    V_$QUEUEING_MTH
    V_$RSRC_CONSUMER_GROUP
    V_$RSRC_CONSUMER_GROUP_CPU_MTH
    V_$RSRC_PLAN
    V_$RSRC_PLAN_CPU_MTH
    V_$SESSION_CONNECT_INFO
    V_$SESSION_LONGOPS
    V_$TEMPORARY_LOBS
    V_$TIMEZONE_NAMES
    V_$VERSION
    WK$$ATTR_MAPPING
    WK$$ATTR_USAGE
    WK$$AUTHBASIC
    WK$$CRAWLER_CONFIG
    WK$$CRAWLER_SCHED
    WK$$DATA_SOURCE
    WK$$DATA_SOURCE_PARAM
    WK$$DATA_SOURCE_PARAM_VAL
    WK$$DATA_SOURCE_TYPE
    WK$$DOC_ATTR
    WK$$GROUP_DS_MAPPING
    WK$$MAILLIST
    WK$$PORTAL
    WK$$PORTAL_DS_MAP
    WK$$SCHED_MAPPING
    WK$$SEARCH_ATTR
    WK$$SEARCH_ATTR_TL
    WK$$SOURCE_GROUP

  5. #5
    Join Date
    Nov 1999
    Posts
    459

    Default RE: What rights/role or SQL used for 'Explore'

    > with the bars a little less than half-way up


    Could be a problem with a special table or field: Set the log level in the "log view" / "log settings" to "row level". Now start the "explore" and see what happens....



    Cheers,
    Jens

  6. #6
    Join Date
    Mar 2006
    Posts
    16

    Default RE: What rights/role or SQL used for 'Explore'

    Looks like you need a role that allows the id you are using to connect to the database to execute on catalog tables.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.