--- In firebird-support@yahoogroups.com, Jaimy Azle <nospam@l...> wrote:

> 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

I knew it would be something easy like that.

Thanks!