어느 가을날의 전환점

ORACLE|오라클 시스템 뷰 (System Views) USER_... 본문

Database/Oracle

ORACLE|오라클 시스템 뷰 (System Views) USER_...

어느가을빛 2010. 12. 2. 00:10
* 현재 로그인 한 사용자(UserID)에 대한 정보 조회
SELECT  U.USERNAME
      , U.USER_ID
      , U.ACCOUNT_STATUS
      , U.LOCK_DATE
      , U.EXPIRY_DATE
      , U.DEFAULT_TABLESPACE
      , U.TEMPORARY_TABLESPACE
      , U.CREATED
      , U.INITIAL_RSRC_CONSUMER_GROUP
      , U.EXTERNAL_NAME
FROM SYS.USER_USERS U;


# 사용자용 뷰
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_AW_PS
USER_AWS
USER_BASE_TABLE_MVIEWS
USER_CATALOG
USER_CLU_COLUMNS
USER_CLUSTER_HASH_EXPRESSIONS
USER_CLUSTERS
USER_COL_COMMENTS
USER_COL_PRIVS
USER_COL_PRIVS_MADE
USER_COL_PRIVS_RECD
USER_COLL_TYPES
USER_CONS_COLUMNS
USER_CONS_OBJ_COLUMNS
USER_CONSTRAINTS
USER_DB_LINKS
USER_DEPENDENCIES
USER_DIM_ATTRIBUTES
USER_DIM_CHILD_OF
USER_DIM_HIERARCHIES
USER_DIM_JOIN_KEY
USER_DIM_LEVEL_KEY
USER_DIM_LEVELS
USER_DIMENSIONS
USER_ERRORS
USER_EVALUATION_CONTEXT_TABLES
USER_EVALUATION_CONTEXT_VARS
USER_EVALUATION_CONTEXTS
USER_EXTENTS
USER_EXTERNAL_LOCATIONS
USER_EXTERNAL_TABLES
USER_FREE_SPACE
USER_GEOMETRY_COLUMNS
USER_IND_COLUMNS
USER_IND_EXPRESSIONS
USER_IND_PARTITIONS
USER_IND_SUBPARTITIONS
USER_INDEXES
USER_INDEXTYPE_OPERATORS
USER_INDEXTYPES
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_LOB_PARTITIONS
USER_LOB_SUBPARTITIONS
USER_LOB_TEMPLATES
USER_LOBS
USER_LOG_GROUP_COLUMNS
USER_LOG_GROUPS
USER_METHOD_PARAMS
USER_METHOD_RESULTS
USER_MVIEW_AGGREGATES
USER_MVIEW_ANALYSIS
USER_MVIEW_DETAIL_RELATIONS
USER_MVIEW_JOINS
USER_MVIEW_KEYS
USER_MVIEW_LOGS
USER_MVIEW_REFRESH_TIMES
USER_MVIEWS
USER_NESTED_TABLES
USER_OBJ_AUDIT_OPTS
USER_OBJ_COLATTRS
USER_OBJECT_SIZE
USER_OBJECT_TABLES
USER_OBJECTS
USER_OPANCILLARY
USER_OPARGUMENTS
USER_OPBINDINGS
USER_OPERATORS
USER_OUTLINE_HINTS
USER_OUTLINES
USER_PART_COL_STATISTICS
USER_PART_HISTOGRAMS
USER_PART_INDEXES
USER_PART_KEY_COLUMNS
USER_PART_LOBS
USER_PART_TABLES
USER_PARTIAL_DROP_TABS
USER_PASSWORD_LIMITS
USER_PENDING_CONV_TABLES
USER_POLICIES
USER_POLICY_CONTEXTS
USER_POLICY_GROUPS
USER_PROCEDURES
USER_PROXIES
USER_PUBLISHED_COLUMNS
USER_QUEUE_PUBLISHERS
USER_QUEUE_SCHEDULES
USER_QUEUE_TABLES
USER_QUEUES
USER_REFRESH
USER_REFRESH_CHILDREN
USER_REFS
USER_REGISTERED_MVIEWS
USER_REGISTERED_SNAPSHOTS
USER_REGISTRY
USER_REPAUDIT_ATTRIBUTE
USER_REPAUDIT_COLUMN
USER_REPCAT
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_REPCATLOG
USER_REPCOLUMN
USER_REPCOLUMN_GROUP
USER_REPCONFLICT
USER_REPDDL
USER_REPFLAVOR_COLUMNS
USER_REPFLAVOR_OBJECTS
USER_REPFLAVORS
USER_REPGENERATED
USER_REPGENOBJECTS
USER_REPGROUP
USER_REPGROUP_PRIVILEGES
USER_REPGROUPED_COLUMN
USER_REPKEY_COLUMNS
USER_REPOBJECT
USER_REPPARAMETER_COLUMN
USER_REPPRIORITY
USER_REPPRIORITY_GROUP
USER_REPPROP
USER_REPRESOL_STATS_CONTROL
USER_REPRESOLUTION
USER_REPRESOLUTION_METHOD
USER_REPRESOLUTION_STATISTICS
USER_REPSCHEMA
USER_REPSITES
USER_RESOURCE_LIMITS
USER_RESUMABLE
USER_ROLE_PRIVS
USER_RSRC_CONSUMER_GROUP_PRIVS
USER_RSRC_MANAGER_SYSTEM_PRIVS
USER_RULE_SET_RULES
USER_RULE_SETS
USER_RULES
USER_RULESETS
USER_SDO_LRS_METADATA
USER_SDO_MAPS
USER_SDO_THEMES
USER_SEGMENTS
USER_SEQUENCES
USER_SNAPSHOT_LOGS
USER_SNAPSHOTS
USER_SOURCE
USER_SOURCE_TAB_COLUMNS
USER_SOURCE_TABLES
USER_SQLJ_TYPE_ATTRS
USER_SQLJ_TYPE_METHODS
USER_SQLJ_TYPES
USER_STORED_SETTINGS
USER_SUBPART_COL_STATISTICS
USER_SUBPART_HISTOGRAMS
USER_SUBPART_KEY_COLUMNS
USER_SUBPARTITION_TEMPLATES
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_TAB_COL_STATISTICS
USER_TAB_COLS
USER_TAB_COLUMNS
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_TABLES
USER_TABLESPACES
USER_TRANSFORMATIONS
USER_TRIGGER_COLS
USER_TRIGGERS
USER_TS_QUOTAS
USER_TYPE_ATTRS
USER_TYPE_METHODS
USER_TYPE_VERSIONS
USER_TYPES
USER_UNUSED_COL_TABS
USER_UPDATABLE_COLUMNS
USER_USERS
USER_USTATS
USER_VARRAYS
USER_VIEWS


저작자표시 비영리 변경금지

'Database > Oracle' 카테고리의 다른 글

ORACLE|실행계획(Explain Plan) 보는 방법  (0) 2010.12.24
ORACLE|Optimizer Mode (옵티마이저 모드)  (0) 2010.12.14
ORACLE|오라클 System Tables  (0) 2010.11.24
ORACLE|테이블(Table) 생성 및 데이터 복사 방법  (0) 2010.08.17
ORACLE|Table Function 과 Pipeline Table Function (테이블 함수)  (0) 2010.07.28
'Database/Oracle' Related Articles more
Comments