Re: Alter any view?

David, Dave, and Rauf,

thank you for your suggestions. David, I originally misunderstood you, sorry for that.

I needed to enable automatic recompilation of invlaid views during select, not recompiling all the invalid objects in a schema. I have some buggy module that invalidates objects from time to time. I enabled automatic recompilation of procedures, functions, and packages by granting alter procedure.

I have just found a solution for my problem. I enabled automatic recompilation of views by
1. granted create view
2. I recreated all the views by another user:
- connected as schema_user

• create view schema_owner.view_name as that done, schema_user has the privilege to automatically recompile the views it created in schema_owner