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 Mon, 06 Apr 2009 14:26:27 GMT
Tiago Espinha wrote:
> Hi everyone,
>
> I am testing the SQL Roles for the 10.5 buddy testing and I'm facing
> some issues. 
Hi Tiago,

I followed the steps you describe and get the following error when tiago 
tries to select from the table.
1) created derby.properties, cut and paste from mail
2) java org.apache.derby.drda.NetworkServerControl start &

 >java org.apache.derby.tools.ij
ij>  connect 
'jdbc:derby://localhost:1527/goodone;create=true;user=adm;password=java';
ij> create table t2 (f1 int, f2 varchar(20));
0 rows inserted/updated/deleted
ij> exit;
[C:/kmarsden/projects/10.5testing/sqlroles] java org.apache.derby.tools.ij
ij version 10.5
ij> connect 
'jdbc:derby://localhost:1527/goodone;user=tiago;password=espinha';
ij> select * from adm.t2;
ERROR 42502: User 'TIAGO' does not have SELECT permission on column 'F1' 
of table 'ADM'.'T2'.
ij>

I am not sure why you are hitting this problem.

Kathey



Mime
View raw message