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
