Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Createing view problem

Createing view problem

From: infested <lukasz.stanczak_at_gmail.com>
Date: 9 May 2006 23:58:27 -0700
Message-ID: <1147244307.041510.297180@y43g2000cwc.googlegroups.com>


I want one user to create view for another, but without granting any view for second one. I know that it is impossible to grant create view on schema, or to log on another schema via plsql query. My idea is that second user creates procedure that do it, and first is able to run it. In fact I don't think it's good way, maybe it is possible to do it more directly.
Thanks in advance.

-- 
Lukasz
Received on Wed May 10 2006 - 01:58:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US