18.12.2018 14:44, 'Bryan Cole' bryan.cole@... [firebird-support] wrote:

> I understand I'm doing it wrong. I don't understand what I need to do different. I've read all the documentation (really!).
>
> If you could give me a working example, that would be awesome.

>isql -u sysdba -p masterkey localhost:employee

SQL> CREATE USER test PASSWORD 'test' GRANT ADMIN ROLE;
SQL> grant RDB$ADMIN to user test;
SQL> commit;

>isql -u test -p test -role RDB$ADMIN localhost:employee

Database: localhost:employee, User: TEST, Role: RDB$ADMIN
SQL> CREATE USER test1 PASSWORD 'test';
SQL> show users;
Users in the database
0 SYSDBA 1 #TEST
0 TEST1

--
WBR, SD.