Re: Permission for other users to create views
Date: Mon, 26 Oct 1998 12:26:25 -0500
Message-ID: <3634B0C1.1896_at_usa.net>
sirirut vanichayobon wrote:
>
> Hi,
> I am having a problem with creating views. I have an account on
> oracle and i have all the permissions for that account. But when i use
> it to create views i am not able to do it. The views i create using the
> tables are not owned by me but by somebody else but i have permission to
> anything with those tables. Is there anyway i can create views on tables
> that are not owned by me?.
> I would apreciate any help. Thanks.
> -Pat
Hello,
The owner of the tables you cannot access, even having all possible
rights, should issue a command GRANT SELECT ON table_name to public (or
to: your_username), then you should be ok.
HTH,
Eva
Received on Mon Oct 26 1998 - 18:26:25 CET