|Subject||Re: Users and Roles Problem|
--- In email@example.com, Jaimy Azle <nospam@l...> wrote:
> On Wednesday, January 12, 2005, 10:29:05 PM, w_y_v_i_s wrote:I knew it would be something easy like that.
> > 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;
> -Jaimy Azle