REVOKE文を使ã?£ã?¦ã€?指定ã?—ã?Ÿãƒ¦ãƒ¼ã‚¶ã?‚ã‚‹ã?„ã?¯å…¨ãƒ¦ãƒ¼ã‚¶ã?‹ã‚‰ã€?データベースã?®æƒ…å ±ã?«å¯¾ã?—ã?¦æ“?作を行ã?†æ¨©é™?を剥奪ã?™ã‚‹ã?“ã?¨ã?Œã?§ã??ã?¾ã?™ã€‚
REVOKE文を発行ã?™ã‚‹å‰?ã?«ã€?derby.database.sqlAuthorization属性ã?Œtrueã?§ã?‚ã‚‹ã?“ã?¨ã‚’確èª?ã?—ã?¦ã??ã? ã?•ã?„。derby.database.sqlAuthorization属性ã?«ã‚ˆã‚Šã€?SQLèª?証ã?Œæœ‰åйã?«ã?ªã‚Šã?¾ã?™ã€‚
æƒ…å ±ã?®æ‰€æœ‰è€…ã?‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã?®æ‰€æœ‰è€…ã?§ã?‚れã?°ã€?ã??ã?®æƒ…å ±ã?¸ã?®æ¨©é™?を剥奪ã?™ã‚‹äº‹ã?Œã?§ã??ã?¾ã?™ã€‚
REVOKEæ–‡ã?®ä½¿ã?„æ–¹ã?¯ã€?表ã?¸ã?®æ¨©é™?を剥奪ã?™ã‚‹ã?®ã?‹ã€?プãƒã‚°ãƒ©ãƒ ルーãƒ?ンã?¸ã?®æ¨©é™?を剥奪ã?™ã‚‹ã?®ã?‹ã?«ã‚ˆã‚Šç•°ã?ªã‚Šã?¾ã?™ã€‚
REVOKE 権é™?タイプ ON [ TABLE ] { 表å?? | ビューå?? } FROM 権é™?を与ã?ˆã‚‰ã‚Œã?¦ã?„ã?Ÿäºº
列ã?®ä¸€è¦§ã‚’指定ã?›ã?šã?«æ¨©é™?を剥奪ã?—ã?Ÿå ´å?ˆã€?表ã?®å…¨ã?¦ã?®åˆ—ã?¸ã?®æ¨©é™?ã?Œå‰¥å¥ªã?•れã?¾ã?™ã€‚
REVOKE EXECUTE ON { FUNCTION | PROCEDURE } プãƒã‚°ãƒ©ãƒ ルーãƒ?ンã?®æŒ‡ç¤ºå? FROM 権é™?を与ã?ˆã‚‰ã‚Œã?¦ã?„ã?Ÿäºº RESTRICT
プãƒã‚°ãƒ©ãƒ ルーãƒ?ンã?«REVOKE文を使ã?†å ´å?ˆã€?RESTRICT節ã?Œå¿…è¦?ã?§ã?™ã€‚RESTRICT節ã?¯ã€?実行権é™?ã?Œãƒ“ューや表ã€?制約ã?‹ã‚‰ã?¯å‰¥å¥ªã?•れã?ªã?„一方ã?§ã€?ビューや表ã€?制約ã?®æ‰€æœ‰è€…ã?‹ã‚‰ã?¯å‰¥å¥ªã?•れるã?“ã?¨ã‚’表ã?—ã?¾ã?™ã€‚
DELETE | INSERT | REFERENCES [列一覧] | SELECT [列一覧] | TRIGGER | UPDATE [列一覧]
権é™?タイプã?®ALL PRIVILEGESã?¯ã€?表ã?¸ã?®å…¨ã?¦ã?®æ¨©é™?をユーザã?‹ã‚‰å‰¥å¥ªã?™ã‚‹æ™‚ã?«ä½¿ã?„ã?¾ã?™ã€‚å?„種権é™?を指定ã?—ã?¦ã€?表ã?¸ã?®ä¸€ã?¤ä»¥ä¸Šã?®æ¨©é™?を剥奪ã?™ã‚‹ã?“ã?¨ã‚‚ã?§ã??ã?¾ã?™ã€‚
DELETE�権�タイプ��表�行を削除�る権�を剥奪�る���使���。
INSERT�権�タイプ��表�行を挿入�る権�を剥奪�る���使���。
REFERENCESã?®æ¨©é™?タイプã?¯ã€?表ã?¸ã?®å¤–部ã‚ーå?‚照を作æˆ?ã?™ã‚‹æ¨©é™?を剥奪ã?™ã‚‹ã?Ÿã‚?ã?«ä½¿ã?„ã?¾ã?™ã€‚列一覧ã?ŒæŒ‡å®šã?•れã?Ÿå ´å?ˆã€?ã??ã?®åˆ—群ã?¸ã?®å¤–部ã‚ーå?‚照を作æˆ?ã?™ã‚‹æ¨©é™?ã? ã?‘ã?Œå‰¥å¥ªã?•れã?¾ã?™ã€‚
SELECTã?®æ¨©é™?タイプã?¯ã€?表ã?¾ã?Ÿã?¯ãƒ“ューã?®æƒ…å ±ã‚’é?¸æŠžã?™ã‚‹æ¨©é™?を剥奪ã?™ã‚‹ã?¨ã??ã?«ä½¿ã?„ã?¾ã?™ã€‚列一覧ã?ŒæŒ‡å®šã?•れã?Ÿå ´å?ˆã€?ã??ã?®åˆ—群ã?¸ã?®æ¨©é™?ã? ã?‘ã?Œå‰¥å¥ªã?•れã?¾ã?™ã€‚列一覧ã?ŒæŒ‡å®šã?•れã?ªã?‹ã?£ã?Ÿå ´å?ˆã€?表ã?®å…¨åˆ—ã?«å¯¾ã?—ã?¦æ“?作ã?Œæœ‰åйã?§ã?™ã€‚
TRIGGER�権�タイプ��表�トリガを作��る権�を剥奪�る���使���。
UPDATEã?®æ¨©é™?タイプã?¯ã€?表ã?«UPDATE文を実行ã?™ã‚‹æ¨©é™?を剥奪ã?™ã‚‹ã?Ÿã‚?ã?«ä½¿ã?„ã?¾ã?™ã€‚列一覧ã?ŒæŒ‡å®šã?•れã?Ÿå ´å?ˆã€?ã??ã?®åˆ—群ã?¸ã?®æ¨©é™?ã? ã?‘ã?Œå‰¥å¥ªã?•れã?¾ã?™ã€‚
{ èª?証è˜åˆ¥å? | PUBLIC } [,{ authorization ID | PUBLIC } ] *
指定ã?—ã?Ÿãƒ¦ãƒ¼ã‚¶ã?‚ã‚‹ã?„ã?¯å…¨ãƒ¦ãƒ¼ã‚¶ã?‹ã‚‰ã€?権é™?ã?®å‰¥å¥ªã‚’行ã?†ã?“ã?¨ã?Œã?§ã??ã?¾ã?™ã€‚全ユーザを指定ã?™ã‚‹ã?¨ã??ã?¯ã€?PUBLICã?¨ã?„ã?†ã‚ーワードを使ã?„ã?¾ã?™ã€‚PUBLICã?§å‰¥å¥ªã?•れる権é™?ã?¨ã€?ユーザを指定ã?—ã?¦å‰¥å¥ªã?•れる権é™?ã?¯ç‹¬ç«‹ã?—ã?Ÿç‰©ã?§ã?™ã€‚例を挙ã?’ã?¾ã?—ょã?†ã€‚表tã?¸ã?®SELECT権é™?ã?Œã€?PUBLICã?¨harryã?¨ã?„ã?†èª?証è˜åˆ¥å?ã?®ä¸¡æ–¹ã?«ä¸Žã?ˆã‚‰ã‚Œã?¦ã?„ã‚‹ã?¨ã?—ã?¾ã?™ã€‚ ã?“ã?“ã?§ã€?harryã?¨ã?„ã?†èª?証è˜åˆ¥å?ã?‹ã‚‰SELECT権é™?ã?Œå‰¥å¥ªã?•れã?Ÿã?¨ã?—ã?¦ã‚‚ã€?harryã?¨ã?„ã?†èª?証è˜åˆ¥å?ã?¯PUBLIC権é™?を通ã?—ã?¦ã€?表tã‚’æ“?作å?¯èƒ½ã?§ã?™ã€‚
剥奪ã?•れã?Ÿæ¨©é™?ã?«ä¾?å˜ã?—ã?¦ã?„るビューやトリガã€?制約ç‰ã?¯è‡ªå‹•çš„ã?«å‰Šé™¤ã?•れã?¾ã?™ã€‚ã?“ã?®ã?¨ã??Derby ã?¯ã€?剥奪ã?•れã?Ÿæ¨©é™?ã‚’ä»–ã?®æ¨©é™?ã?§ä»£æ›¿ã?—よã?†ã?¨ã?—ã?¾ã?›ã‚“。詳ã?—ã??ã?¯ã€?Derby ディベãƒãƒƒãƒ‘ーズ ガイドã?®"SQL standard authorization"ã‚’å?‚ç…§ã?—ã?¦ã??ã? ã?•ã?„。
REVOKEæ–‡ã?«ã?¯æ¬¡ã?®åˆ¶é™?äº‹é …ã?Œã?‚りã?¾ã?™ã€‚
権é™?を付与ã?•れã?Ÿãƒ¦ãƒ¼ã‚¶ã?Œè¡¨ã?¸ã?®ã?„ã?šã‚Œã?‹ã?®æ¨©é™?ã‚’å¿…è¦?ã?¨ã?™ã‚‹æƒ…å ±ã‚’ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã?«ä½œæˆ?ã?™ã‚‹ã?¨ã€?Derby ã?®ã‚¨ãƒ³ã‚¸ãƒ³ã?¯ã€?ã??ã?®æƒ…å ±ã?ŒSYSTABLEPERMSã?«ã?‚る特定ã?®è¡Œã?¸ä¾?å˜ã?—ã?¦ã?„ã‚‹ã?“ã?¨ã‚’ç?†è§£ã?—ã?¾ã?™ã€‚ 例ã?ˆã?°ã€?user2ã?ŒSELECT * FROM user1.t1ã?¨ã?„ã?†æ–‡ã?§v1ã?¨ã?„ã?†ãƒ“ューを作æˆ?ã?™ã‚‹ã?¨ã€?ビューã?®v1ã?¨ã€?GRANTEE欄ã?Œuser2ã?§TABLEID欄ã?Œuser1.t1ã?§ã?‚ã‚‹SYSTABLEPERMSã?®è¡Œã?¨ã?®é–“ã?«ã€?管ç?†å¯¾è±¡ã?¨ã?ªã‚‹ä¾?å˜é–¢ä¿‚ã?Œã?‚ã‚‹ã?¨ãƒ—ãƒã‚°ãƒ©ãƒ ã?¯ç?†è§£ã?—ã?¾ã?™ã€‚ã?“ã?“ã?§ã€?プãƒã‚°ãƒ©ãƒ ã?¯ãƒ“ューã?Œç‰¹å®šã?®è¡Œã?«ä¾?å˜ã?—ã?¦ã?„ã‚‹ã?“ã?¨ã‚’ç?†è§£ã?—ã?¾ã?™ã?Œã€?ã??ã?®è¡Œã?«ã?‚る権é™?ã?«å¯¾å¿œã?—ã?Ÿæ¬„ã?®ã?†ã?¡ã€?ã?©ã?®æ¬„ã?«ä¾?å˜ã?—ã?¦ã?„ã‚‹ã?®ã?‹ã?¯ç?†è§£ã?—ã?¦ã?„ã?¾ã?›ã‚“。
ã??ã?®ã?›ã?„ã?§ã€?表毎ã?®æ¨©é™?を剥奪ã?™ã‚‹REVOKEæ–‡ã?Œç™ºè¡Œã?•れるã?¨ã€?ã??ã?®æ¨©é™?ã?¨å?Œã?˜è¡¨IDã?¨ãƒ¦ãƒ¼ã‚¶ã?®çµ„ã?¿å?ˆã‚?ã?›ã‚’æŒ?ã?¤æ¨©é™?ã?«ä¾?å˜ã?—ã?Ÿãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä¸Šã?®æƒ…å ±ã?¯å…¨ã?¦å‰Šé™¤ã?•れã?¦ã?—ã?¾ã?„ã?¾ã?™ã€‚例ã?§èª¬æ˜Žã?™ã‚‹ã?¨ã€?user1ã?Œuser2ã?‹ã‚‰è¡¨t1ã?®DELETE権é™?を剥奪ã?™ã‚‹ã?¨ã€?SYSTABLEPERMS表ã?®GRANTEE欄ã?«user2ã‚’ã?¨ã‚ŠTABLEID欄ã?«user1.t1ã‚’ã?¨ã‚‹è¡Œã?ŒREVOKEæ–‡ã?«ã‚ˆã‚Šæ›´æ–°ã?•れã?¾ã?™ã€‚ã?“ã?®ã?¨ã??ä¾?å˜é–¢ä¿‚ã?®ç®¡ç?†æ©Ÿèƒ½ã?«ã‚ˆã‚Šã€?ã??ã?®è¡Œã?«è¨˜éŒ²ã?•れã?ŸDELETE権é™?ã?«ã?¯ä¾?å˜ã?—ã?¦ã?„ã?ªã?„ã?«ã‚‚ã?‹ã?‹ã‚?らã?šã€?権é™?ã?®å‰¥å¥ªã?«ã‚ˆã‚‹ç„¡åŠ¹åŒ–ã?®ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã?Œuser2.v1ã?«ã‚‚é€?ä¿¡ã?•れるã?®ã?§ã€?ã?“ã?®ãƒ“ューã?¯å‰Šé™¤ã?•れã?¦ã?—ã?¾ã?„ã?¾ã?™ã€‚
表ã?®åˆ—ã?®é›†å?ˆã?«æ¨©é™?を付与ã?•れã?Ÿãƒ¦ãƒ¼ã‚¶ã?Œã€?ã??ã?®æ¨©é™?ã?«ä¾?å˜ã?—ã?Ÿæƒ…å ±ã‚’ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã?«ä½œæˆ?ã?—ã?Ÿå ´å?ˆã€?Derbyã?¯ã€?ã??ã?®æƒ…å ±ã?¨SYSCOLPERMS表ã?®å¯¾å¿œã?—ã?Ÿè¡Œã?®é–“ã?®ä¾?å˜é–¢ä¿‚ã‚’ç?†è§£ã?—ã?¦ç®¡ç?†ä¸‹ã?«èµ·ã??ã?¾ã?™ã€‚例ã?ˆã?°user2ã?ŒSELECT c11 FROM user1.t1ã?¨ã?„ã?†æ–‡ã?«ã‚ˆã‚Šã€?v1ã?¨ã?„ã?†è¡Œã‚’作æˆ?ã?™ã‚‹ã?¨ã€?プãƒã‚°ãƒ©ãƒ ã?¯GRANTEE欄ã?Œuser2ã?§TABLEID欄ã?Œuser1.t1ã€?TYPE欄ã?ŒSã?§ã?‚ã‚‹SYSCOLPERMS表ã?®è¡Œã?«ã€?v1ã?Œä¾?å˜ã?™ã‚‹ã?“ã?¨ã‚’ç?†è§£ã?—ã?¦ã€?ã??ã?®ä¾?å˜é–¢ä¿‚を管ç?†ä¸‹ã?«ç½®ã??ã?¾ã?™ã€‚ã?“ã?®ã?¨ã??ã€?プãƒã‚°ãƒ©ãƒ ã?¯ãƒ“ューã?ŒSELECT権é™?ã?«ä¾?å˜ã?™ã‚‹ã?“ã?¨ã?¯ç?†è§£ã?—ã?¾ã?™ã?Œã€?ビューã?Œã?©ã?®ã‚«ãƒ©ãƒ ã?«ä¾?å˜ã?—ã?¦ã?„ã‚‹ã?‹ã?¯è¿½è·¡ã?—ã?¾ã?›ã‚“。
REVOKEæ–‡ã?Œã‚«ãƒ©ãƒ ã?”ã?¨ã?®æ¨©é™?ã?«å¯¾ã?—ã?¦ç™ºè¡Œã?•れるã?¨ã€?ã??ã?®æ¨©é™?ã?®æ¨©é™?付与先ã€?テーブルIDã€?権é™?ã?®ç¨®é¡žã?«ä¾?å˜ã?—ã?Ÿãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä¸Šã?®æƒ…å ±ã?Œå‰Šé™¤ã?•れã?¾ã?™ã€‚例ã?§èª¬æ˜Žã?™ã‚‹ã?¨ã€?user1ã?Œuser2ã?‹ã‚‰ã€?表user1.t1ã?®åˆ—c12ã?¸ã?®SELECT権é™?を剥奪ã?™ã‚‹ã?¨ã€?GRANTEE欄ã?Œuser2ã?§TABLEIDã?Œuser1.t1ã€?TYPE欄ã?ŒSã?®SYSCOLPERMSã?«ã?‚る行ã?Œã€?REVOKEæ–‡ã?«ã‚ˆã‚Šæ›´æ–°ã?•れã?¾ã?™ã€‚ã?“ã?®ã?¨ã??ä¾?å˜é–¢ä¿‚ã?®ç®¡ç?†æ©Ÿèƒ½ã?«ã‚ˆã‚Šã€?c12 ã?¨ã?„ã?†åˆ—ã?«ã?¯ä¾?å˜ã?—ã?¦ã?„ã?ªã?„ã?«ã‚‚ã?‹ã?‹ã‚?らã?šã€?権é™?ã?®å‰¥å¥ªã?«ã‚ˆã‚‹ç„¡åŠ¹åŒ–ã?®ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã?Œuser2.v1ã?¨ã?„ã?†ãƒ“ューã?«ã‚‚é€?ä¿¡ã?•れるã?®ã?§ã€?ã?“ã?®ãƒ“ューã?¯å‰Šé™¤ã?•れã?¦ã?—ã?¾ã?„ã?¾ã?™ã€‚
REVOKE SELECT ON TABLE t FROM maria,harry
REVOKE UPDATE, TRIGGER ON TABLE t FROM anita,zhi
REVOKE SELECT ON TABLE s.v FROM PUBLIC
REVOKE UPDATE (c1,c2) ON TABLE s.v FROM PUBLIC
pã?¨ã?„ã?†æ‰‹ç¶šã??ã?¸ã?®EXECUTE権é™?ã‚’ã€?georgeã?¨ã?„ã?†èª?証è˜åˆ¥å?ã?‹ã‚‰å‰¥å¥ªã?™ã‚‹å ´å?ˆã€?次ã?®ã‚ˆã?†ã?«æ–‡ã‚’書ã??ã?¾ã?™ã€‚
REVOKE EXECUTE ON PROCEDURE p FROM george RESTRICT