"ORACLEæ°æ®åå
¸è§å¾çç§ç±»åå«ä¸ºï¼USER,ALL å DBA.
ããUSER_*:æå
³ç¨æ·ææ¥æç对象信æ¯ï¼å³ç¨æ·èªå·±å建ç对象信æ¯
ããALL_*:æå
³ç¨æ·å¯ä»¥è®¿é®ç对象çä¿¡æ¯ï¼å³ç¨æ·èªå·±å建ç对象çä¿¡æ¯å ä¸
ããå
¶ä»ç¨æ·å建ç对象ä½è¯¥ç¨æ·ææ访é®çä¿¡æ¯
ããDBA_*:æå
³æ´ä¸ªæ°æ®åºä¸å¯¹è±¡çä¿¡æ¯
ãã(è¿éç*å¯ä»¥ä¸ºTABLES,INDEXES,OBJECTS,USERSçã)
ãã1ãæ¥çææç¨æ·
ããselect * from dba_user;
ããselect * from all_users;
ããselect * from user_users;
ãã2ãæ¥çç¨æ·ç³»ç»æé
ããselect * from dba_sys_privs;
ããselect * from all_sys_privs;
ããselect * from user_sys_privs;
ãã3ãæ¥çç¨æ·å¯¹è±¡æé
ããselect * from dba_tab_privs;
ããselect * from all_tab_privs;
ããselect * from user_tab_privs;
ãã4ãæ¥çææè§è²
ããselect * from dba_roles;
ãã5ãæ¥çç¨æ·ææ¥æçè§è²
ããselect * from dba_role_privs;
ããselect * from user_role_privs;
ãã6ãæ¥çå½åç¨æ·ç缺ç表空é´
ããselect username,default_tablespace from user_users;
ãã7ãæ¥çæ个è§è²çå
·ä½æé
ããå¦grant connect,resource,create session,create view to TEST;
ãã8ãæ¥çRESOURCEå
·æé£äºæé
ç¨SELECT * FROM DBA_SYS_PRIVS WHERE GRANTEE='RESOURCE
"
温馨提示:答案为网友推荐,仅供参考