Database/DataModule with Interbase connects to a gdb file shows +Tables but no show after click on +

Thread View: borland.public.jbuilder.database

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by Mehmet F. Erten Thu, 13 Jul 2006 21:38

#213

Author: Mehmet F. Erten
Date: Thu, 13 Jul 2006 21:38

8 lines
1676 bytes

I created three separate database files (gdb) in InterBase 7.5.1.
Two of them has only one table in it and I can see them in JBuilderX's 
QueryDataSet design screen. (Table and its columns)
But the my main data qdb with many tables (created same way through "load 
script" with create table statements and after alter table primary keys) 
does not show any table after I clicked on +Tables although I can see the 
system tables (no problem to connect any one of them).
Thanks for any hint.

Re: Database/DataModule with Interbase connects to a gdb file shows +Tables but no show after click on +

#214

Author: paul nichols [TeamB]
Date: Fri, 14 Jul 2006 02:29

12 lines
1707 bytes

Mehmet F. Erten wrote:
> I created three separate database files (gdb) in InterBase 7.5.1.
> Two of them has only one table in it and I can see them in JBuilderX's 
> QueryDataSet design screen. (Table and its columns)
> But the my main data qdb with many tables (created same way through "load 
> script" with create table statements and after alter table primary keys) 
> does not show any table after I clicked on +Tables although I can see the 
> system tables (no problem to connect any one of them).
> Thanks for any hint. 
> 
> 
What permissions and what schema are these tables in?

Re: Database/DataModule with Interbase connects to a gdb file shows +Tables but no show after click on +

#215

Author: Mehmet F. Erten
Date: Fri, 14 Jul 2006 13:47

30 lines
2492 bytes

Hi,
All three gdb do not have any grant permissions statements in metaview.
Show Permission On is for SYSDBA
but no Show Permission For values.
Although all 3 same, 2 of the 3 have only one table in it and I can see them 
through JBuilder but can not see if many tables
Looks like I have to add the following statement for each table in my sql 
creation file.
GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON ##### TO PUBLIC WITH 
GRANT OPTION;
Thanks for asking the right question.

/* Grant Roles for this database */

/* Grant permissions for this database */

"paul nichols [TeamB]" <user@domain.invalid> wrote in message 
news:44b70193$1@newsgroups.borland.com...
> Mehmet F. Erten wrote:
>> I created three separate database files (gdb) in InterBase 7.5.1.
>> Two of them has only one table in it and I can see them in JBuilderX's 
>> QueryDataSet design screen. (Table and its columns)
>> But the my main data qdb with many tables (created same way through "load 
>> script" with create table statements and after alter table primary keys) 
>> does not show any table after I clicked on +Tables although I can see the 
>> system tables (no problem to connect any one of them).
>> Thanks for any hint.
> What permissions and what schema are these tables in?

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads