y use
SELECT * FROM table1
where connected as user2. That should produce exactly the same result.
Cheers,
Christian Sage
-Ursprüngliche Nachricht-
Von: M. Jang [mailto:[EMAIL PROTECTED]]
Gesendet am: Dienstag, 18. September 2001 18:16
An: [EMAIL PROTECTED]
Betreff: Re: Oracle prepare f
Hello,
I'm sorry to be slightly off topic but how can u access table of
other user? (mean, the syntax)
I made 'user1' and 'user2'. user1 is the owner of table1.
the 'system' granted 'connect' role to user2, and user1 granted
select on table1 to user2.
When user2 tries 'select * from table1', ge
Actually, that was my error, not Kevin's. It ended up being a typo on one
of the table names. I did not cut and paste from sqlplus into the DBI
script, I retyped it, and while reviewing the code several times, it took
someone else's eyes to see my mistake.
Thanks anyway,
-Mike
At 11:00 AM
Kevin,
Your error is 'table or view does not exist'.
Did you connect as the same Oracle user in SQL*Plus and perl ?
Mark
Kevin Bass wrote:
> Please post your entire statement:
>
> my $sth = $dbh->prepare(qq(SELECT fuser.us_initl, . . .
>
> Thanks
>
> - Original Message -
> From: "Mic
Please post your entire statement:
my $sth = $dbh->prepare(qq(SELECT fuser.us_initl, . . .
Thanks
- Original Message -
From: "Michael Ragsdale" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 17, 2001 3:00 PM
Subject: Oracle prepare failed?
> I have a query that
No, they weren't. However, the username does have "select any table"
privileges granted to him. I just logged into sqlplus with the same
username that is in the DBI script and it did indeed work just fine via
sqlplus. I'm at a loss.?
At 04:04 PM 09/17/2001, Dong Wang wrote:
>are the
are the usernames used in dbi the same as in sqlplus?
Since it is a ORA-00942 error, it is possible that
1. the user connected through dbi does not own the table
2. there is no synonym created for the dbi user so that tables have to be
qualified as
schema.table_name
3. there is no select privile
