20.6 Firebird User Management

User information is maintained in the security database security.db

CREATE USER kayon PASSWORD 'secret';
COMMIT;
GRANT SELECT, INSERT, UPDATE, DELETE ON PATIENT TO kayon;
ALTER USER sysdba SET PASSWORD 'new';
DROP USER kayon;
sudo isql-fb -user sysdba /var/lib/firebird/3.0/system/security3.fdb
SQL> show tables;
       PLG$SRP                                PLG$USERS
SQL> select plg$user_name from plg$srp;

PLG$USER_NAME 
=============================== 
SYSDBA 
KAYON 


Your donation will support ongoing availability and give you access to the PDF version of this book. Desktop Survival Guides include Data Science, GNU/Linux, and MLHub. Books available on Amazon include Data Mining with Rattle and Essentials of Data Science. Popular open source software includes rattle, wajig, and mlhub. Hosted by Togaware, a pioneer of free and open source software since 1984. Copyright © 1995-2022 Graham.Williams@togaware.com Creative Commons Attribution-ShareAlike 4.0