Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Createing view problem
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.
-- LukaszReceived on Wed May 10 2006 - 01:58:27 CDT
![]() |
![]() |