Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Privilege to create views on my own schema based on tables in other schema
You indicate that you have "select" privileges on the tables in the other schema. If this privilege is granted through a role, it will not work. You will need either explicit privileges on the object (ie. grant select on table to schema_owner) or the "select any table" privilege granted to the schema owner.
Hope this helps.
Dave
Maggie wrote:
> What is the privilege that I should have in order to create views on my own
> schema based on tables on other schema?
>
> I already "select" privilege on tables in that schema and "create view "
> privilege on my own schema. I tried to creat a view on my own schema based
> on the table in other schema but I kept getting "table or view does not
> exist" error message.
>
> Please help.
Received on Wed Aug 09 2000 - 00:00:00 CDT