ããç³»ç»æé: å
许ç¨æ·æ§è¡ç¹å®çæ°æ®åºå¨ä½ï¼å¦å建表ãå建索å¼ãè¿æ¥å®ä¾çï¼å¯¹ç¨æ·èè¨ï¼
ãã对象æé: å
许ç¨æ·æ纵ä¸äºç¹å®ç对象ï¼å¦è¯»åè§å¾ï¼å¯æ´æ°æäºåãæ§è¡åå¨è¿ç¨çï¼æ¯é对表æè§å¾èè¨çï¼
ãã1.ç³»ç»æé
ããè¶
è¿ä¸ç¾å¤ç§ææçæéï¼SELECT * FROM SYSTEM_PRIVILEGE_MAPæ¥ï¼
ããæ°æ®åºç®¡çåå
·æé«çº§æé以å®æ管çä»»å¡ï¼ä¾å¦:
ããâå建æ°ç¨æ·
ããâå é¤ç¨æ·
ããâå é¤è¡¨
ããâå¤ä»½è¡¨
ããç³»ç»æéåç±»ï¼
ããDBA: æ¥æå
¨é¨ç¹æï¼æ¯ç³»ç»æé«æéï¼åªæDBAæå¯ä»¥å建æ°æ®åºç»æã
ããRESOURCE:æ¥æResourceæéçç¨æ·åªå¯ä»¥å建å®ä½ï¼ä¸å¯ä»¥å建æ°æ®åºç»æã
ããCONNECT:æ¥æConnectæéçç¨æ·åªå¯ä»¥ç»å½Oracleï¼ä¸å¯ä»¥å建å®ä½ï¼ä¸å¯ä»¥å建æ°æ®åºç»æã
ãã对äºæ®éç¨æ·ï¼æäºconnect, resourceæéã
ãã对äºDBA管çç¨æ·ï¼æäºconnectï¼resource, dbaæéã
ããa.常ç¨çç³»ç»æéï¼
ããCREATE SESSION å建ä¼è¯
ããCREATE SEQUENCE å建åºå
ããCREATE SYNONYM å建åå对象
ããCREATE TABLE å¨ç¨æ·æ¨¡å¼ä¸å建表
ããCREATE ANY TABLE å¨ä»»ä½æ¨¡å¼ä¸å建表
ããDROP TABLE å¨ç¨æ·æ¨¡å¼ä¸å é¤è¡¨
ããDROP ANY TABLE å¨ä»»ä½æ¨¡å¼ä¸å é¤è¡¨
ããCREATE PROCEDURE å建åå¨è¿ç¨
ããEXECUTE ANY PROCEDURE æ§è¡ä»»ä½æ¨¡å¼çåå¨è¿ç¨
ããCREATE USER å建ç¨æ·
ããDROP USER å é¤ç¨æ·
ããCREATE VIEW å建è§å¾
ãã2.对象æé
ããä¸åç对象å
·æä¸åç对象æé
ãã对象çæ¥æè
æ¥ææææé
ãã对象çæ¥æè
å¯ä»¥åå¤åé
æé
ããORACLEä¸å
±æç§å¯¹è±¡æé
ãã对象æé 表 è§å¾ åºå è¿ç¨
ããä¿®æ¹(alter) â â
ããå é¤(delete) â â
ããæ§è¡(execute) â
ããç´¢å¼(index) â
ããæå
¥(insert) â â
ããå
³è(references) â â
ããéæ©(select) â â â
ããæ´æ°(update) â â
温馨提示:答案为网友推荐,仅供参考