FirebirdSQL/2/4

* [http://deleltoule.com/sittatrocerb.html chirolrola]
http://c4tboba.com/litrocr.html[chirolrola] [[http://c4tboba.com/litrocr.html][chirolrola]]
* http://vidarra.com/chichibo.html chirolrola
* [[http://ercnapa.com/elttrr.html chirolrola]]
* [[http://varnoc4.com/ouracc4t.html|chirolrola]]
* [[http://lidomtrocric.com/lacnadelt.html | chirolrola]]
* [http://getorm.com/paszelboroba.html|chirolrola]
* [chirolrola|http://caelolo.com/boalchi.html]
* ((http://boouri.com/rozelv.html chirolrola))
* [chirolrola](http://riccnaromon.com/dronget.html "chirolrola")
"chirolrola":http://livarcc4trel.com/elcnaelch.html
 
http://www.textlidelalt.com 
=== 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]