Re: Who is the owner?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Fri, 03 Dec 1999 09:29:15 -0500
Message-ID: <frkf4s0nqe4276s1c683fcik5f0vi4iatf@4ax.com>

A copy of this was sent to "Joe" <Dont_at_Send.Com> (if that email address didn't require changing) On Fri, 3 Dec 1999 09:51:10 -0000, you wrote:

>Oracle 7.3
>
>What happens when User 'Me' creates a view as ORC.View_name
>
>Who is the owner? the actual creator 'Me' or the Schema owner 'ORC'?
>
>Thanks
>Joe
>

orc owns the view. me cannot grant on it until orc grants me access with grant option. for example:

tkyte_at_8i> create view scott.v as select * from dual;

View created.

tkyte_at_8i> grant select on scott.v to public; grant select on scott.v to public

                      *

ERROR at line 1:
ORA-01031: insufficient privileges

tkyte_at_8i> create view v as select * from dual;

View created.

tkyte_at_8i> grant select on v to public;

Grant succeeded.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri Dec 03 1999 - 08:29:15 CST