On Wednesday, January 12, 2005, 10:29:05 PM, w_y_v_i_s wrote:

> I am a firebird newbie and I am having a few problems with users and
> roles. Simple scenario: I want to create a DB, add a table, create a
> role with privileges and finally create a new user with the role.

> Step 4: Login as user and try it
> Use CONNECT or CREATE DATABASE to specify a database
> SQL>> connect "D:\ROLETEST.FDB" user TESTUSER password t3stus3r;
> Database: "D:\ROLETEST.FDB", User: TESTUSER
> SQL>> select * from COUNTRIES;
> Statement failed, SQLCODE = -551
> no permission for read/select access to TABLE COUNTRIES

Just specify which role should be used when login, this because you
can assign multiple roles for testuser.

SQL> connect "D:\ROLETEST.FDB" user TESTUSER password t3stus3r role
CON> testrole;

--
Salam,

-Jaimy Azle