Oracle ²é¿´Óû§È¨ÏÞÒÔ¼°Ë÷Òý

1.²é¿´ËùÓÐÓû§
     select * from all_users; -------²é¿´ËùÓеÄÓû§
     select * from user_users; --------²é¿´µ±Ç°Óû§
2.²é¿´Óû§»ò½ÇɫϵͳȨÏÞ£º
     select * from user_sys_privs; --------²é¿´µ±Ç°Óû§µÄȨÏÞ
3.²é¿´½ÇÉ«Ëù°üº¬µÄȨÏÞ
     select * from role_sys_privs;   -------
4.²é¿´Óû§¶ÔÏóȨÏÞ
     select * from all_tab_privs;   --------²é¿´ËùÓõÄÓû§µÄ¿É²Ù×÷±íȨÏÞ
     select * from user_tab_privs; --------²é¿´µ±Ç°Óû§µÄ±í¿É²Ù×÷ȨÏÞ
5.²é¿´Óû§»ò½ÇÉ«ËùÓµÓеĽÇÉ«
     select * from user_role_privs;   ------²é¿´µ±Ç°Óû§µÄ½ÇÉ«
²é¿´±íµÄÔ¼ÊøÌõ¼þ°üº¬£ºÖ÷¼ü Íâ¼ü¡£ ÒÔ¼°Ë÷Òý
select * from user_constraints where TABLE_NAME='£¿';    -----²é¿´Ä³Ò»¸ö±íµÄÔ¼Êø
select constraint_type,constraint_name,search_condition from all_constraints
where table_name='£¿';
select * from user_cons_columns where TABLE_NAME='£¿';   -----ijһ¸öÔ¼ÊøµÄ¹¹³É
select index_name,index_type,status,blevel from user_indexes where table_name = '£¿';   -----²é¿´Ä³Ò»¸ö±íµÄËùÓÐË÷Òý
SELECT table_name, index_name, column_name, column_position from user_ind_columns WHERE table_name='£¿';    ----²é¿´Ë÷ÒýµÄ¹¹³É