FirebirdSQL/2/4

=== SYSDBA user ===
SYSDBA useræ¯Firebird Serveré è¨çä½¿ç¨èï¼ä¹æ¯ç®¡çå¡å¸³èï¼å»ºè°å®è£ä¹å¾ï¼æå¥½è½æ¹è®å¶å¯ç¢¼æèæ°å¢ä¸åæ°çç®¡çå¡å¸³èï¼Firebird Serverä½¿ç¨èå¸³èæ¯åå¨æ¼security.fdbï¼


=== ç³»çµ±æ¬éè³æåº« security.fdb ===
*userè³æè¡¨--éè¦æ¬ä½èªªæ
||  Column          ||         èªªæ  ||        
|| User nameã|| ä½¿ç¨èå¸³è,æé·å¯è¼¸å¥128åå || 
|| Password || ä½¿ç¨èå¯ç¢¼,æé·å¯è¼¸å¥128åå || 
|| UID || æ´æ¸åæçä½¿ç¨èID ||
|| GID || æ´æ¸åæçç¾¤çµID ||
|| Full name || ä½¿ç¨èå¨å ||

=== ç¾¤çµå»ºç«æ¹å¼ ===
# å»ºç«è¦å CREATE ROLE.
#:CREATE ROLE sales;
# è®æ´ç¾æè³æè¡¨è¦å(table1)
#:GRANT UPDATE ON table1 TO sales;
# è®æ´ç¾æè³æè¡¨è¦å(user1, user2, user3)
#:GRANT sales TO user1, user2, user3;
# æå¾,ç¨è®æ´å¾çä½¿ç¨èå¸³èç»å¥è³æåº«
#:CONNECT âfoo.gdbâ USER âuser1â PASSWORD âpeanutsâ ROLE sales;


=== ä½¿ç¨ Firebird API æ¹å¼æ§å¶ç³»çµ±æ¬é ===
è¦ä½¿ç¨ API æ§å¶ç³»çµ±æ¬éæ¹å¼çå½æ¸æisc_add_user( ), isc_delete_user( ), and isc_modifiy_user( ).

è©³ç´°è³æè«åè APIæå 


=== gsec command-line tool ===
*gsecæä»¤åæ¸èªªæè¡¨
||  æä»¤          ||         èªªæ  ||        
|| di[splay]ã|| ååº security.fdb ææè³æ || 
|| di[splay] name || é¡¯ç¤ºææä½¿ç¨è || 
|| a[dd] name -pw password [option argument] [option argument ...] || æ°å¢ security.fdb çä½¿ç¨è||
|| mo[dify] name [options] || ä¿®æ¹ security.fdb çä½¿ç¨è ||
|| de[lete] name  || åªé¤ security.fdb çä½¿ç¨è ||
|| h[elp] or ?  || gsec æä»¤èèªæ³èªªæ ||
|| q[uit]|| é¢é gsec æä»¤æ¨¡å¼ ||

*optionsåæ¸èªªæè¡¨
||  Option          ||         èªªæ  ||        
|| -password or -pa stringã|| Password of user who is performing the change || 
|| -user string|| User who is performing the change || 
|| -pw string || Target user password||
|| -uid integer || Target user ID ||
|| -gid integer || Group ID for target user ||
|| -fname string || First Name for target user ||
|| -mname string || Middle Name for target user ||
|| -lname string || Last Name for target user ||

*gsecä½¿ç¨èªªæ
**å·è¡gsec: gsec -user sysdba -password masterkey
**é ç«¯å·è¡gsec: gsec -database jupiter:/usr/interbase/isc4.gdb
**å¢å ä½¿ç¨è'jones': GSEC> add jones -pw welcome
**é¡¯ç¤ºè¨é: GSEC> display
**ä¿®æ¹ä½¿ç¨èåç¨±: GSEC> modify cbrown âuid 8 âfname cindy
**é¡¯ç¤ºä½¿ç¨è'cbrown'è¨é: GSEC> display cbrown
**åªé¤ä½¿ç¨è'cbrow': GSEC> delete cbrown

=== åèæç«  ===
#[http://vfp.sunyear.com.tw/viewtopic.php?t=1556 Firebirdçå®å¨è¨å®PowerPoint]