Re: Rights needed to connect oracle7 DB

"Romain A" <romain.anselin_at_mort_au_spam_club-internet.fr> wrote in message news:40b5fefd$0$305$7a628cd7_at_news.club-internet.fr...
> "Randy Harris" wrote:
>
> > Who owns PHOTO?
> >
>
> I have no owner, the database contain 6 tables for an application..

You may not have an owner, but PHOTO does. How were you logged into Oracle when you created the table? That user will own the table. If you wish to access the table as a different user, you will need to include the schema information (for example SELECT * from joeuser.PHOTO) or else create a synonym for that. Hopefully, you didn't create the tables as sys.

> Only the administrators (we are 2) have a sys, internal and system
access.
> I want the user to be able to select on each table and have full DML
> commands rights on a specific table. The structure is not big enough to
have
> owners on parts of it, I think...and my users do not need other rights
(and
> do not know).
> Do I have to create owner and if it is the case is there someone who
would
> explain me what does the owner and why do I need it?
>
>
Received on Thu May 27 2004 - 12:42:24 CDT