🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.jbuilder.database
Article #215

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

#215
From: 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? 
Technical Details
Message-ID: <44b7a07a$1@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newscon06.news.prodigy.com!newscon02.news.prodigy.com!prodigy.net!news-out.superfeed.net!sp6iad.superfeed.net!in1.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail
References: <44b6bd4b$1@newsgroups.borland.com> <44b70193$1@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Thread: 1073da,1e9535ae47ee3f25
X-Google-Attributes: gid1073da,public
X-Google-Language: ENGLISH,ASCII-7-bit
Subject: Re: Database/DataModule with Interbase connects to a gdb file shows +Tables but no show after click on +
From: "Mehmet F. Erten" <mehmet_erten@mblsoft.com>
Date: Fri, 14 Jul 2006 09:47:29 -0400
Message-ID: <44b7a07a$1@newsgroups.borland.com>
References: <44b6bd4b$1@newsgroups.borland.com> <44b70193$1@newsgroups.borland.com>
Lines: 32
NNTP-Posting-Host: 71.250.239.59
Organization: MBL Systems, Inc
Path: arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newscon06.news.prodigy.com!newscon02.news.prodigy.com!prodigy.net!news-out.superfeed.net!sp6iad.superfeed.net!in1.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail
Newsgroups: borland.public.jbuilder.database
X-Trace: newsgroups.borland.com 1152884858 71.250.239.59 (14 Jul 2006 06:47:38 -0700)
Reply-to: "Mehmet F. Erten" <mehmet_erten@mblsoft.com>
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
X-RFC2646: Format=Flowed; Response