Tiago Espinha wrote:
5) Tried to use TIAGO on another ij spawn and here is what I get:
ij> select * from adm.t1;
ERROR 42502: User 'TIAGO' does not have SELECT permission on column 'F1' of table 'ADM'.'T1'.

I think before you do the select, you have to set the role, e.g
ij>set role readRole;

Should we make this clearer in the documentation?
http://db.apache.org/derby/docs/dev/devguide/cdevcsecureroles.html

Kathey

Reply via email to