Re: Rights needed to connect oracle7 DB

From: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Thu, 27 May 2004 00:40:36 +0200
Message-ID: <t07ab0pr2egbd0gfeftb9bfr2ikjhd41ou@4ax.com>

On Wed, 26 May 2004 22:30:06 +0200, "Romain A" <romain.anselin_at_mort_au_spam_club-internet.fr> wrote:

>Seen something on the owner of the table but I'm bothered, after 3 days on
>the subject, I still do not find...

Are you the owner of the object(s)?
If so, they should appear by
select object_name from user_objects

Is someone else owner of the object(s) and you have been grant access? If so they should appear by
select owner, object_name from all_objects

If this is true you either need to prefix the owner before the table name
select * from <owner>.photo
or set up a synonym
create synonym photo for <owner>.photo

The Application Developers Manual has more info on this stuff, reading Oracle Concepts is also warmly recommended.

--
Sybrand Bakker, Senior Oracle DBA

Received on Wed May 26 2004 - 17:40:36 CDT