History of Firebird - Building TEST_USER

Create a new user, DEMO_USER, using Flamerobin's Manage Users from the server drop down menu. Generic password programmed into ibtest and ibtest_pdo is 'demotest', but that can be changed as required. The full name works well as Ibtest Demo User, and once created, a matching DEMO_ROLE can be created in the employee demo database.

CREATE ROLE DEMO_ROLE;
SELECT RDB$ROLE_NAME FROM RDB$ROLES;
GRANT CREATE TABLE TO DEMO_ROLE;
GRANT CREATE PROCEDURE TO DEMO_ROLE;
GRANT DEMO_ROLE TO DEMO_USER;

Things to look out for are that /opt/firebird/examples/empbuild/employee.fdb is owned by firebird:firebird, and that it is correctly identified in the database.conf file. A normal install will have created it along with the correct entries, but if you have built your own database.conf it may be missing.

Create a new user, DEMO_USER, using Flamerobin's Manage Users from the server drop down menu. Generic password programmed into ibtest and ibtest_pdo is 'demotest', but that can be changed as required. The full name works well as Ibtest Demo User, and once created, a matching DEMO_ROLE can be created in the employee demo database.

CREATE ROLE DEMO_ROLE;
SELECT RDB$ROLE_NAME FROM RDB$ROLES;
GRANT CREATE TABLE TO DEMO_ROLE;
GRANT CREATE PROCEDURE TO DEMO_ROLE;
GRANT DEMO_ROLE TO DEMO_USER;

Drop the above into Execute SQL Statements in FlameRobin and run it in one hit ... but remember to commit once it's completed!

Things to look out for are that /opt/firebird/examples/empbuild/employee.fdb is owned by firebird:firebird, and that it is correctly identified in the database.conf file. A normal install will have created it along with the correct entries, but if you have built your own database.conf it may be missing.

FlameRobin Link