""demco_eng"" <demco.eng@...> wrote in message
news:a5sbfh+e7cq@......

> Good Day,
>
> I am using firebird RC2 and have created some roles in the database.
> these include full access to tables and some only select access. I
> have also created various users. Running D4 Pro I am trying to log
> into the DB granting a user a role of say Select only. I continually
> get the error that the user has not got access to the tables.

The SQL standard says that no role is attached to a user automagically and
there's no thing as a default role. You should specify the role every time
you log in or it doesn't have any effect.

It depends on the components you use how you specify the role.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing