Hi all,
We are having strange problem. I have granted a user
select any table role in webdb. However when that
user goes to build component he can not other users
tables but he can see tables from system, sys ...
Is there a bug in webdb ???
TIA.
- David Barbour <DBarbour_at_connectsouth.com> wrote:
> Ashish,
>
> I haven't done anything with the gateway or DADs.
> When I run a query, if
> the data I need is in a different DB, I have a DB
> Link to the source. So
> for instance, if I'm gathering customer data, my Web
> user is running out of
> the Customer Database. I also need some trouble
> ticket information from
> Remedy, and billing information from Portal. I have
> DB Links to both those
> databases, and have created synonyms for the tables
> I use there, so they
> appear to the Web user to be residing in its "home"
> database, the customer
> DB.
>
> Hope this helps.
>
> David A. Barbour
> Oracle DBA - ConnectSouth
> 512-681-9438
> dbarbour_at_connectsouth.com
>
>
> -----Original Message-----
> From: Ashish Shah [mailto:ar_shah_at_yahoo.com]
> Sent: Thursday, October 05, 2000 2:34 PM
> To: DBarbour_at_connectsouth.com
> Subject: RE: WEBDB
>
>
> David,
>
> Thanks for the reply.
>
> I have install webdb on different database. But now
> when I change settings in PL/SQL gateway I am
> getting
> lots of error.. like..
>
> ORA-06550: line 5, column 2:
> PLS-00201: identifier 'WEBDB.HOMEMENU' must be
> declared
> ORA-06550: line 5, column 2:
> PL/SQL: Statement ignored
>
>
> Any ideas..
>
> What settings I have to change in PL/SQL settings
> page
> if I have to switch the databases ?
>
>
> Database Access Descriptor Name
>
> Oracle User Name
> Oracle Password
> Oracle Connect String
>
> Maximum Number of Worker Threads
> Keep Database Connection Open between Requests?
> Default (Home) Page
> Document Table
> Document Access Path
> Document Access Procedure
> SSL ENABLED (CGI ONLY)
>
> --- David Barbour <DBarbour_at_connectsouth.com> wrote:
> > Ashish,
> >
> > I'm connecting to data from seven different
> > databases, not all on the same
> > machine. Use db links and synonyms.
> >
> > David A. Barbour
> > Oracle DBA - ConnectSouth
> > 512-681-9438
> > dbarbour_at_connectsouth.com
> >
> >
> > -----Original Message-----
> > Sent: Thursday, October 05, 2000 1:45 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hi all,
> >
> > Is it possible to create webdb packages on only
> > one database and then access objects from all
> other
> > databases? Or I must install webdb packages in
> all
> > databases.
> >
> > Currently I have created webdb schima on one test
> > database. So when I launch webdb i can see
> objects
> > from that database. But i want to create web
> pages
> > using objects from other databases on same machine
> > ...
> >
> > Let me know what u think or if there is any
> document
> > that explains...
> >
> > TIA.
> >
> >
> > =====
> > Ashish
> > Toronto, Canada
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Yahoo! Photos - 35mm Quality Prints, Now Get 15
> > Free!
> > http://photos.yahoo.com/
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: Ashish Shah
> > INET: ar_shah_at_yahoo.com
> >
> > Fat City Network Services -- (858) 538-5051
> FAX:
> > (858) 538-5051
> > San Diego, California -- Public Internet
> > access / Mailing Lists
> >
>
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be
> removed
> > from). You may
> > also send the HELP command for other information
> > (like subscribing).
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: David Barbour
> > INET: DBarbour_at_connectsouth.com
> >
> > Fat City Network Services -- (858) 538-5051
> FAX:
> > (858) 538-5051
> > San Diego, California -- Public Internet
> > access / Mailing Lists
> >
>
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be
> removed
> > from). You may
> > also send the HELP command for other information
> > (like subscribing).
>
>
> =====
> Ashish
> Toronto, Canada
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Photos - 35mm Quality Prints, Now Get 15
> Free!
> http://photos.yahoo.com/
Received on Fri Oct 06 2000 - 09:33:28 CDT
