[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 848
  • Last Modified:

materialized view refresh

I have a materialized view in schema 1 and i can refresh it in schema1.Now i want my schema2 in the same database to have the privileges to refresh a materialized view owned by schema1.what privileges should i grant schema2
0
suhinrasheed
Asked:
suhinrasheed
1 Solution
 
ravindran_eeeCommented:
Schema2 should have select rights on the underlying tables of the materialized and the materialized view itself.. This should be sufficient.. The refresh should look like,

EXECUTE DBMS_SNAPSHOT.REFRESH('tiger.temp');

Please let me know whether any further information is needed..
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now