GRANT 文を使ã?£ã?¦ã€?データベースã?«ã?‚ã‚‹æƒ…å ±ã?®æ“?作権é™?ã‚’ã€?指定ã?—ã?Ÿä¸€äººã?‚ã‚‹ã?„ã?¯å…¨ãƒ¦ãƒ¼ã‚¶ã?«ä¸Žã?ˆã‚‹ã?“ã?¨ã?Œã?§ã??ã?¾ã?™ã€‚
GRANT文を発行ã?™ã‚‹å‰?ã?«ã€?derby.database.sqlAuthorization属性ã?Œtrueã?§ã?‚ã‚‹ã?“ã?¨ã‚’確èª?ã?—ã?¦ã??ã? ã?•ã?„。derby.database.sqlAuthorization属性ã?«ã‚ˆã‚Šã€?SQLèª?証ã?Œæœ‰åйã?«ã?ªã‚Šã?¾ã?™ã€‚
ユーザã?«æ¨©é™?付与ã?Œèª?ã‚?られã?¦ã?„ã‚‹æƒ…å ±ã?§ã?‚れã?°ã€?ã??ã?®æƒ…å ±ã?¸ã?®æ¨©é™?をユーザã?¯ä¸Žã?ˆã‚‹ã?“ã?¨ã?Œã?§ã??ã?¾ã?™ã€‚ 詳細ã?«ã?¤ã?„ã?¦ã?¯ã€?権é™?を与ã?ˆã‚ˆã?†ã?¨ã?—ã?¦ã?„ã‚‹æƒ…å ±ã?«å¯¾å¿œã?—ã?ŸCREATEæ–‡ã?®èª¬æ˜Žæ–‡ã‚’èªã‚“ã?§ã??ã? ã?•ã?„。
GRANTæ–‡ã?®æ›¸ã??æ–¹ã?¯ã€?表ã?«å¯¾ã?™ã‚‹æ¨©é™?付与ã?ªã?®ã?‹ã€?ã??れã?¨ã‚‚プãƒã‚°ãƒ©ãƒ ルーãƒ?ンã?«å¯¾ã?™ã‚‹æ¨©é™?付与ã?ªã?®ã?‹ã?«ã‚ˆã‚Šã€?ã??ã?®æ§‹æ–‡ã?Œç•°ã?ªã‚Šã?¾ã?™ã€‚
GRANT 権é™?タイプ ON [TABLE] { 表å?? | ビューå?? } TO 権é™?を与ã?ˆã‚‰ã‚Œã‚‹äºº
GRANT EXECUTE ON { FUNCTION | PROCEDURE } プãƒã‚°ãƒ©ãƒ ルーãƒ?ンã?®æŒ‡ç¤ºå? TO 権é™?を与ã?ˆã‚‰ã‚Œã‚‹äºº
DELETE | INSERT | REFERENCES [列一覧] | SELECT [列一覧] | TRIGGER | UPDATE [列一覧]
ALL PRIVILEGES権��より指定��表������権�をユーザ�付与���。権��並�を指定���表��一�以上�権�を付与�る��も�能��。
DELETE権��より指定��表�ら行を削除�る権�を付与���。
INSERT権��より指定��表�行を挿入�る権�を付与���。
REFERENCES権é™?ã?«ã‚ˆã‚ŠæŒ‡å®šã?—ã?Ÿè¡¨ã?¸ã?®å¤–部ã‚ーå?‚照を作æˆ?ã?™ã‚‹æ¨©é™?を付与ã?—ã?¾ã?™ã€‚REFERENCESã?«å?ˆã‚?ã?›ã?¦åˆ—並ã?³ã?ŒæŒ‡å®šã?•れã?Ÿå ´å?ˆã€?指定ã?—ã?Ÿåˆ—ã?¸ã?®å¤–部ã‚ーå?‚ç…§ã? ã?‘ã?Œè¨±å?¯ã?•れã?¾ã?™ã€‚
SELECT権é™?ã?«ã‚ˆã‚Šè¡¨ã?‚ã‚‹ã?„ã?¯ãƒ“ューã?§SELECT文を行ã?†æ¨©é™?ã?Œä»˜ä¸Žã?•れã?¾ã?™ã€‚ã‚‚ã?—SELECT権é™?ã?§åˆ—ã?®ä¸¦ã?³ã?ŒæŒ‡å®šã?•れã?Ÿå ´å?ˆã€?ã??れらã?®åˆ—ã?«ã?®ã?¿æ¨©é™?ã?¯æœ‰åйã?§ã?™ã€‚列ã?®ä¸¦ã?³ã?ŒæŒ‡å®šã?•れã?ªã?‹ã?£ã?Ÿå ´å?ˆã€?表ã?®å…¨åˆ—ã?«ã?¤ã?„ã?¦æ¨©é™?ã?¯æœ‰åйã?§ã?™ã€‚
TRIGGER権��より指定��表�トリガを作��る権��付与�れ��。
UPDATE権é™?ã?«ã‚ˆã‚ŠæŒ‡å®šã?—ã?Ÿè¡¨ã?«UPDATE文を使ã?†æ¨©é™?ã?Œä»˜ä¸Žã?•れã?¾ã?™ã€‚列ã?®ä¸¦ã?³ã?ŒæŒ‡å®šã?•れã?Ÿå ´å?ˆã€?権é™?ã?¯æŒ‡å®šã?•れã?Ÿåˆ—ã?«ã?®ã?¿æœ‰åйã?§ã?™ã€‚WHERE節ã?®ã?‚ã‚‹æ–‡ã?§è¡Œã‚’æ›´æ–°ã?™ã‚‹å ´å?ˆã€?æ›´æ–°ã?™ã‚‹è¡Œã?«ã?‚る列ã?¸ã?®SELECT権é™?ã‚‚å¿…è¦?ã?§ã?™ã€‚
{ èª?証è˜åˆ¥å? | PUBLIC } [,{ èª?証è˜åˆ¥å? | PUBLIC } ] *
特定ã?®ãƒ¦ãƒ¼ã‚¶ã?¾ã?Ÿã?¯å…¨ãƒ¦ãƒ¼ã‚¶ã?«æ¨©é™?を与ã?ˆã‚‹ã?“ã?¨ã?Œã?§ã??ã?¾ã?™ã€‚ PUBLIC ã?¨ã?„ã?†ã‚ーワードã?¯å…¨ãƒ¦ãƒ¼ã‚¶ã‚’ã?‚らã‚?ã?—ã?¾ã?™ã€‚PUBLICã?Œä¸Žã?ˆã‚‰ã‚Œã?Ÿå ´å?ˆã€?ç?¾å˜ã?™ã‚‹ãƒ¦ãƒ¼ã‚¶ã?®ã?¿ã?ªã‚‰ã?šã€?以é™?ã?«ä½œæˆ?ã?•れã?Ÿãƒ¦ãƒ¼ã‚¶ã?«ã‚‚権é™?ã?Œä¸Žã?ˆã‚‰ã‚Œã?¾ã?™ã€‚ PUBLICã?«ä¸Žã?ˆã‚‰ã‚Œã?Ÿæ¨©é™?ã?¨ã€?個々ã?®ãƒ¦ãƒ¼ã‚¶ã?«ä¸Žã?ˆã‚‰ã‚Œã?Ÿæ¨©é™?ã?¯ã€?独立ã?—ã?¦ã?„ã?¾ã?™ã€‚ 例ã?ˆã?°ã€?tã?¨ã?„ã?†è¡¨ã?¸ã?®SELECT権é™?ã?Œã€?PUBLICã?¨harryã?¨ã?„ã?†èª?証è˜åˆ¥å?ã?«å¯¾ã?—ã?¦ä¸Žã?ˆã‚‰ã‚Œã?¦ã?„ã‚‹ã?¨ã?—ã?¾ã?—ょã?†ã€‚ã?“ã?®å ´å?ˆã?¯ã€?harryã?¨ã?„ã?†èª?証è˜åˆ¥å?ã?‹ã‚‰SELECT権é™?ã?Œå‰¥å¥ªã?•れã?Ÿã?¨ã?—ã?¦ã‚‚ã€?Harryã?¯PUBLICã?®æ¨©é™?を通ã?—ã?¦ã€?tã?¨ã?„ã?†è¡¨ã‚’æ“?作å?¯èƒ½ã?§ã?™ã€‚
GRANT SELECT ON TABLE t TO maria,harry
GRANT UPDATE, TRIGGER ON TABLE t TO anita,zhi
GRANT SELECT ON TABLE s.v to PUBLIC
pã?¨ã?„ã?†æ‰‹ç¶šã??ã?®å®Ÿè¡Œæ¨©é™?ã‚’ã€?georgeã?¨ã?„ã?†èª?証è˜åˆ¥å?ã?«ä¸Žã?ˆã‚‹ã?«ã?¯ã€?次ã?®ã‚ˆã?†ã?«æ›¸ã??ã?¾ã?™ã€‚
GRANT EXECUTE ON PROCEDURE p TO george