Subject | Converting Interbase Database to Firebird |
---|---|
Author | Steve Harp |
Post date | 2005-08-24T02:18:24Z |
Hi All,
I need to convert an Interbase v7.1 database to Firebird v1.52. I did
a backup (gbak) of the IB database using IB and restored it using FB
using the same user needed to run the application. Is there anything
else I need to do?
Also, I'm having a problem with priviledge. I'm using IBExpert and I
can open the database connection with the user (say my_user) and look
at metadata and so forth. The problem is when I try to do a select.
If I (select * from my_table) I get an error
"This user does not have priviledge to perform this operation on this
object. No permission for read/select access to COLUMN my_column.".
However, if I take any table in IBExpert's Database Explorer and
double click to display the Table dialog snd then select the grants
tab, the user shows full (green dot) rights to everything.
What am I missing here?
Steve
I need to convert an Interbase v7.1 database to Firebird v1.52. I did
a backup (gbak) of the IB database using IB and restored it using FB
using the same user needed to run the application. Is there anything
else I need to do?
Also, I'm having a problem with priviledge. I'm using IBExpert and I
can open the database connection with the user (say my_user) and look
at metadata and so forth. The problem is when I try to do a select.
If I (select * from my_table) I get an error
"This user does not have priviledge to perform this operation on this
object. No permission for read/select access to COLUMN my_column.".
However, if I take any table in IBExpert's Database Explorer and
double click to display the Table dialog snd then select the grants
tab, the user shows full (green dot) rights to everything.
What am I missing here?
Steve