db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kathey Marsden <kmarsdende...@sbcglobal.net>
Subject Re: Issues with SQL Roles
Date Thu, 09 Apr 2009 16:00:39 GMT
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

Mime
View raw message