Article View: borland.public.jbuilder.database
Article #215Re: Database/DataModule with Interbase connects to a gdb file shows +Tables but no show after click on +
From: Mehmet F. Erten
Date: Fri, 14 Jul 2006 13:47
Date: Fri, 14 Jul 2006 13:47
30 lines
2492 bytes
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-mailReferences:
<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