. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 5.1. User management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 5.1.2. Adding Firebird user accounts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34 6.3.3. Creating a database as a non-privileged user . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35 6.4. Firebird SQL

.............................................................................................. 15 User management: gsec ................................................................................ Firebird server executable. • One or more client libraries. • The command-line tools. • The standard user-defined function libraries. • A sample database. • The C header files (not needed by beginners). • gstat.exe, etc. \bin Sample database employee.fdb \examples\ empbuild User-defined function (UDF) li- braries ib_udf.dll, fbudf.dll \UDF Additional server-side

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 4.2. Protecting User Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . operating system refer to relevant documentation for that operating system, to discover how to apply user and object security in Firebird databases refer to documentation available from the Firebird website For an application (user) to access a Firebird database it must connect to the Firebird server process. On receiving a connect request the server process will authenticate the user credentials against

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 10. Setting The ISC_USER And ISC_PASSWORD Environment Variables. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . containing a batch of SQL statements in sequence without prompting. ◦ Add and modify data. ◦ Grant user permissions. ◦ Perform database administrative functions. • Directly from the command line, with individual completion, return control automatically to the operating system. • In a non-interactive session, the user employs a shell script or batch file to perform database functions.  Because other applications

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 4.1. Displaying User Details . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 5.1. Displaying User Details . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . privileged user) the ability to maintain user accounts for various Firebird databases. Using various options, users can be added, amended or deleted from the security database.  A privileged user is an

server ............................................................................... 11 Default user name and password ............................................................................... executable. • A client library located on the server machine. • The command-line tools. • The standard user-defined function libraries. • A sample database. • The C header files (not needed by beginners!) Server can run as non-root user, e.g. firebird. This limits the damage in case of malfunctioning (by hack or otherwise). No Services Manager. Tasks like backup/ restore, user management, stats etc. have

specified is invalid -85 335544752 dup_usrname_found A duplicate user name was found in the security database -85 335544753 usrname_not_found The user name specified was not found in the security database -85 rd An error occurred while attempting to add the user. -85 335544755 error_modifying_sec_record An error occurred while attempting to modify the user record. -85 335544756 error_deleting_sec_record An An error occurred while attempting to delete the user record. -85 335544757 error_updating_sec_db An error occurred while updating the security database. Firebird 1.5 Error Codes Updated 04/30/04 p.

is invalid -85 335544752 dup_usrname_found A duplicate user name was found in the security database -85 335544753 usrname_not_found The user name specified was not found in the security database -85 d An error occurred while attempting to add the user. -85 335544755 error_modifying_sec_record An error occurred while attempting to modify the user record. -85 335544756 error_deleting_sec_record An error occurred while attempting to delete the user record. -85 335544757 error_updating_sec_db An error occurred while updating the security database. -103 335544571 dsql_constant_err Data type

password for the appropriate user to be read from a file as opposed to being specified on the command line. The file name supplied is not in quotes and must be readable by the user running gbak. If the file file name is specified as stdin, then the user will be prompted for a password. On POSIX systems, the file name /dev/tty will also result in a prompt for the password.  Firebird 2.5 onwards. -M[ETA_DATA] be used by the connecting user. Not of much practical use and is not normally used in practice. -U[SER] Allows the username of the SYSDBA or database owner user to be specified if the database

specified is invalid -85 335544752 dup_usrname_found A duplicate user name was found in the security database -85 335544753 usrname_not_found The user name specified was not found in the security database -85 rd An error occurred while attempting to add the user. -85 335544755 error_modifying_sec_record An error occurred while attempting to modify the user record. -85 335544756 error_deleting_sec_record An An error occurred while attempting to delete the user record. -85 335544757 error_updating_sec_db An error occurred while updating the security Firebird 2.1 Error Codes database. -103 335544571 dsql_constant_err