Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    50

    Arrow Unanswered: view all objects permission

    Hi

    Which role should I assign to user so that he can see all the objects (tables, triggers etc. ) but can edit only those to which he has right to edit.


    Thanks
    Ishan

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    SQL> select view_name
    2 from dba_views
    3 where view_name like 'ALL%';

    VIEW_NAME
    ------------------------------
    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_AUDIT_POLICIES
    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_INDEXES
    ALL_INDEXTYPES
    ALL_INDEXTYPE_COMMENTS
    ALL_INDEXTYPE_OPERATORS
    ALL_IND_COLUMNS
    ALL_IND_EXPRESSIONS
    ALL_IND_PARTITIONS
    ALL_IND_SUBPARTITIONS
    ALL_INTERNAL_TRIGGERS
    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_OPERATOR_COMMENTS
    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_SECONDARY_OBJECTS
    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_VIEWS
    ALL ITEMS 5/6 DIGITS

    198 rows selected.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •