考试网 >> IT认证 >> Oracle >> Oracle指导 >> Oracle常用数据字典

发布时间：2006-06-28 09:21     点击：

ALL_SNAPSHOTS Snapshots the user can look at  

ALL_SOURCE Current source on stored objects that user is allowed to create  

ALL_SYNONYMS All synonyms accessible to the user  

ALL_TABLES Description of tables accessible to the user  

ALL_TAB_COLUMNS Columns of all tables, views and clusters  

ALL_TAB_COMMENTS Comments on tables and views accessible to the user  

ALL_TAB_GRANTS_MADE User's grants and grants on user's objects  

ALL_TAB_GRANTS_RECD Grants on objects for which the user or PUBLIC is the grantee  

ALL_TAB_PRIVS Grants on objects for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee  

ALL_TAB_PRIVS_MADE User's grants and grants on user's objects  

ALL_TAB_PRIVS_RECD Grants on objects for which the user, PUBLIC or enabled role is the grantee  

ALL_TRIGGERS Triggers accessible to the current user  

ALL_TRIGGER_COLS Column usage in user's triggers or in triggers on user's tables  

ALL_USERS Information about all users of the database  

ALL_VIEWS Text of views accessible to the user  

USER_AUDIT_CONNECT Audit trail entries for user logons/logoffs  

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_SESSION 　

USER_AUDIT_STATEMENT Audit trail records concerning grant, revoke, audit, noaudit and alter system  

USER_AUDIT_TRAIL Audit trail entries relevant to the user  

发表评论： 匿名发表 用户名: 查看评论

您将承担一切因您的行为、言论而直接或间接导致的民事或刑事法律责任 留言板管理人员有权保留或删除其管辖留言中的任意内容 本站提醒：不要进行人身攻击。谢谢配合。