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