What grants are needed to alter create views in another schema?
582007Jul 4 2007 — edited Jul 4 2007Hi all.
I want to execute "alter view user2.table compile;" with user user1 but I get the error ORA-01031: insufficient privileges. It works if I give the alter any table grant to user1.
But security politic is restrictive and I cannot give this grant to user1. I gave him the alter table to user2.table but it doesn't work.
Must I give another grant to user1?
And I have the same problem with the creation of a view. Is it possible to grant user1 to create a view only in user2 schema?