/usr/share/doc/firebird2.5-common-doc/doc/README.UserSql is in firebird2.5-doc 2.5.4.26856.ds4-1build1.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 | Issue:
======
New SQL operators to maintain user accounts.
Scope:
======
Affects firebird versions starting with 2.5.
Document author:
=================
Alex Peshkov (peshkoff@mail.ru)
Document date: Fri Dec 28 2007
==============
Added following DSQL operators:
CREATE USER name PASSWORD 'pass' [FIRSTNAME 'text'] [MIDDLENAME 'text'] [LASTNAME 'text'];
ALTER USER name [SET] [PASSWORD 'pass'] [FIRSTNAME 'text'] [MIDDLENAME 'text'] [LASTNAME 'text'];
DROP USER name;
At least one of PASSWORD / FIRSTNAME / MIDDLENAME / LASTNAME is required in ALTER USER.
Non-privileged (non-SYSDBA) user can use only ALTER USER operator with his own name
as name parameter in it.
WARNING! These operators do not support 2 phase commit - changes in secure DB
take place at first (prepare) phase, and there is no limbo state in it.
|