October 7th, 2003, 03:31 AM
|
|
Junior Member
|
|
Join Date: Oct 2003
Location: NRW/Germany
Posts: 3
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Problem with roles on Firebird 1.5
Hi,
I encountered some problems regarding grant and roles in the latest Firebird build.
Here's a basic test-case that reproduces the problem:
Code:
~/>>isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database '~/Data/User/Test.fdb';
SQL> create table test( Field1 Integer, Field2 VarChar(30) );
SQL> create role test_role;
SQL> grant select on test to role test_role;
SQL> grant test_role to dalbu;
SQL> exit;
~/>>isql -u dalbu -p password
Use CONNECT or CREATE DATABASE to specify a database
SQL> connect ~/Data/User/test.fdb;
Database: ~/Data/User/test.fdb, User: dalbu
SQL> select * from test;
Statement failed, SQLCODE = -551
no permission for read/select access to TABLE TEST
SQL>
How's that possible? Are roles broken on Firebird 1.5, or is something wrong with my SQL?
Can someone test this with other Firebird versions?
thanks for any help,
Daniel Albuschat
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
