Firebird Command Line Russian

  • Published on
    26-Aug-2014

  • View
    52

  • Download
    8

Embed Size (px)

Transcript

FirebirdNorman Dunbar

FirebirdNorman Dunbar : , , : 2004 Copyright 2004 Norman Dunbar

1. ........................................................................................................................................... 1 2. GSEC - .................................................................... 3 ....................................................................................................................................... 3 ............................................................................................................. 4 GSEC ............................................................................................................................. 6 ................................................................................................................. 7 ............................................................................... 8 ......................................................................................... 8 .............................................................................. 9 ................................................... 9 ................................................................................................................ 10 .............................................................................................. 10 ......................................................................................................................... 10 ............................................................................. 11 ....................................................................................... 11 ............................................................................. 11 ................................................. 12 .............................................................................................. 12 GSEC ............................................................................................................ 13 Firebird 2 .......................................................................................................... 13 GSEC ..................................................................................................... 14 .................................................................... 14 .................................................................. 14 ................................................................................ 15 GSEC .............................. 15 3. GSPLIT - .............................................................................. 16 ..................................................................................................................................... 16 GSPLIT .............................................................................................. 17 GSPLIT .......................................................................................................... 18 ....................................................................................................... 18 ................................................................................ 19 4. Firebird Linux/Unix ........................................................................................... 21 ..................................................................................................................................... 21 SYSDBA ....................................................................................................... 21 ...................................................................................... 22 createAliasDB.sh ................................................................................... 23 makefile ....................................................................................................... 23 fb_config .................................................................................................................. 23 Firebird ............................................................................. 24 SSchangeRunUser.sh ............................................................................ 25 root Firebird ....................................................................... 25 Embedded ClientServer .......................................................................... 26 5. ... ...................................................................................................................... 27 A: ........................................................................................ 28

iv

1

: Firebird 1.5 , Firebird . , , - . /bin ( \bin Windows) , Firebird. Linux /opt/firebird/ bin, , Windows c:\program files\firebird\ firebird_1_5\bin. FB_LOCK_PRINT - , . GBAK - . . GDEF - , Interbase 4.0, 6 ( ). GDEF, , . GFIX , (on-line) (shutdown) , "" (in-limbo), , . GPRE - , , SQL, Firebird API. GSEC - . ( ) Firebird. , , . GSPLIT - , , , . Windows , , . , GBAK , GSPLIT . Unix , GSPLIT, . GSTAT Firebird . ISQL - , Firebird. ( ), Firebird. ISQL - .

1

QLI - Query Language Interpreter, Interbase 4.0, 6.0, Interbase . , Linux Unix. . , ( ), CVS, . , .

2

2

GSEC - :

GSEC - ( ). ( ) Firebird. , , . GSEC, SYSDBA. .

Firebird . Firebird, , security.fdb. Firebird 2 security2.fdb. : C:\Program Files\Firebird\Firebird_x_x Windows ( x_x - Firebird, 1_5). /opt/firebird Linux Unix-. - users host_info. host_info , users , Firebird. Firebird 2 , . , . GSEC users . , . users 3

GSEC , . , password () GSEC, . Firebird, GSEC , , , . : GSEC. GSEC. GSEC , : - ; - ; - ; - . GSEC . GSEC.

GSEC, . : -user SYSDBA, , , . , ISC_USER ISC_PASSWORD. -password , . , ISC_USER ISC_PASSWORD. -role SQL-, . -database , . , . -z GSEC . -help 4

GSEC :gsec utility - maintains user password database command line usage: gsec [ ... ] [ ... ] interactive usage: gsec [ ... ] GSEC> [ ... ] available options: -user -password -role -database -z available commands: adding a new user: add [ ... ] deleting a current user: delete displaying all users: display displaying one user: display modifying a user's parameters: modify [ ... ] help: ? (interactive only) help displaying version number: z (interactive only) quit interactive session: quit (interactive only) available parameters: -pw -uid -gid -fname -mname -lname

:gsec - : gsec [ ... ] [ ... ] : gsec [ ... ] GSEC> [ ... ]

5

GSEC

: -user < > -password < > -role < SQL- > -database < > -z : : add [ ... ] : delete : display : display : modify [ ... ] : ? ( ) help : z ( ) : quit ( ) : -pw -uid -gid -fname -mname -lname

GSEC , . , . . -add [ ... ] . , , . , modify. -delete . , .

6

GSEC -display [ ] , . . -modify [ ... ] . - , Firebird. : -pw . 8 . GSEC , . -uid -gid -uid -gid POSIX- userid ( ) groupid ( ) Unix, /etc/passwd /etc/group. , .

-fname [ ] . , . , , . -mname [ ] . , . , , . -lname [ ] . , . , , .

GSEC : 7

GSECC:\>gsec -user sysdba -password masterkey GSEC>

GSEC> , . -user -password , . , sysdba. . GSEC quit:GSEC> quit C:\>

, . , sysdba.

:GSEC> display user name uid gid full name -----------------------------------------------------------------------SYSDBA 0 0 NORMAN 0 0 Norman Dunbar EPOCMAN 0 0 Benoit Gilles Mascia GSEC>

display, .GSEC> display epocman user name uid gid full name -----------------------------------------------------------------------EPOCMAN 0 0 Benoit Gilles Mascia GSEC>

, , .GSEC> display alison GSEC>

. display display , , .GSEC> add newuser -pw newuser -fname New -lname User

8

GSECGSEC> GSEC> display newuser user name uid gid full name -----------------------------------------------------------------------NEWUSER 0 0 New User GSEC>

. display display , , .GSEC> delete newuser GSEC> GSEC> display user name uid gid full name -----------------------------------------------------------------------SYSDBA 0 0 NORMAN 0 0 Norman Dunbar EPOCMAN 0 0 Benoit Gilles Mascia GSEC>

.GSEC> delete newuser record not found for user: NEWUSER C:\>

, . . display display , , .GSEC> modify norman -pw newpassword GSEC> GSEC> modify norman -mname MiddleName -fname Fred GSEC> GSEC> display norman user name uid gid full name -------------------------------------------