I have a select that works fine. However, it doesn't work fine when I try
to create a view of the result set. There is nothing particularly fancy
about the query, just a plethora of outer joins from the main table to the
secondary tables. I get an error back about one of the tables not
Hi
Dan,
are
you referencing public synonyms in your statement?
Lisa
Rutland KoivuOracle Database
Administrator[EMAIL PROTECTED]4850 N.
State Rd. 7, #G104
Ft.
Lauderdale, FL 33319
Phone:
954.484.3191
Now
that is one fancy signature!
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, LisaSent:
Thursday, April 05, 2001 1:03 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: Select won't work for view
create
Hi
Dan
work for view
create
Now
that is one fancy signature!
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, LisaSent:
Thursday, April 05, 2001 1:03 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: Select won't work
Dan,
To
create a view on a table, you must have Select granted directly to your User,
not just via a Role, which works for Selects.
Maybe
that's it.
Jack
Jack C.
ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit,
Inc.Austin,
Yea, I noticed that.
Lisa musta gotta
raise.
(congrats!)
-Original Message-From: Kevin Kostyszyn
[mailto:[EMAIL PROTECTED]]Sent: Thursday, April 05, 2001 1:27
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Select won't work for view create
Now
that is one
Title: RE: Select won't work for view create
-Original Message-
From: Dasko, Dan [mailto:[EMAIL PROTECTED]]
I have a select that works fine. However, it doesn't
work fine when I try to create a view of the result set.
There is nothing particularly fancy about the query, just
Title: RE: Select won't work for view create
That
was the problem. Thanks.
Dan
-Original Message-From: Jacques Kilchoer
[mailto:[EMAIL PROTECTED]]Sent: Thursday, April 05, 2001
2:31 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: Select won't work for view create
for view create
Yea, I noticed
that.
Lisa musta gotta
raise.
(congrats!)
-Original Message-From: Kevin Kostyszyn
[mailto:[EMAIL PROTECTED]]Sent: Thursday, April 05, 2001 1:27
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Select won't work for view
-LSubject:
RE: Select won't work for view create
Now that is one fancy signature!
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, LisaSent:
Thursday, April 05, 2001 1:03 PMTo: Multiple recipients
10 matches
Mail list logo