Re: DDL and Dynamic SQL

Oren Nakdimon wrote:
>
> Nasier.
> Grant CREATE ANY VIEW to MAIN_USER.
>
> Because, when USER1 is executing TEST_SQL, it is like being executed by
> MAIN_USER, so MAIN_USER is trying to create a view in USER1's schema, and
> for doing that MAIN_USER needs a privilege to create a view in other user's
> schema.
>
> USER1 needs only the "execute on test_sql" privilege. He doesn't need the
> "create view" and the "execute on dbms_sql".

Another note: If TEST_SQL does a "SELECT user FROM dual INTO current_user;" it will get "MAIN_USER". The process which calls TEST_SQL should pass the user name in as a parameter.

Hope this helps
Ken Denny
kendenny_at_bnr.ca (work)
kdenny_at_interpath.com (home) Received on Tue Oct 21 1997 - 00:00:00 CDT