Re: DDL and Dynamic SQL

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".

--


====================================================

Oren Nakdimon
Golden Screens Ltd.
address: 17 Abba-Hillel st., Ramat-Gan 52522, ISRAEL
email:   oren_at_gsit.co.il
tel:     +972-3-7510836
fax:     +972-3-7518221


====================================================