History of Firebird - Building TEST_USER

<p>Create a new user, DEMO_USER, using Flamerobin&#39;s Manage Users from the server drop down menu. Generic password programmed into ibtest and ibtest_pdo is &#39;demotest&#39;, 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.</p>

<pre>
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;
</pre>

<p>Drop the above into Execute SQL Statements in FlameRobin and run it in one hit ... but remember to commit once it&#39;s completed!</p>

<p>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.</p>

<p>FlameRobin Link</p>