Hi Nico,

> I don't succeed to grant privileges to a user with a ROLE. I did
> the following : I've created a simple table to the test,
> named 'ROLETEST'. NCW is my username.
>
> 1) CREATE ROLE NEW_ROLE
> 2) GRANT SELECT ON ROLETEST TO NEW_ROLE
> 3) GRANT NEW_ROLE TO NCW
>
> When I log on with NCW and try to read from the table, I got the
> error message : no permission for read/select access to TABLE ROLETEST

Do you also specify this role when logging on?


With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase
Firebird Workbench - the developer tool for Firebird
Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."