Is there any sense in creating materialized views from one schema to another in same database ? Will a public synonym or a simple view suffice? Please suggest
Asked
Active
Viewed 64 times
0
-
1You can simply access the data like SELECT * FROM schema.table; and not need any additional objects. – Nov 25 '14 at 13:15
1 Answers
1
The question is about the same as if you ask if it makes sense to have the same table in another schema of the database. If anybody who can access materialized view / table has access to the schema why bother? And even if not I would ask why they have no access to the schema.
Your question: Will a public synonym or a simple view suffice? That said, I also would say yes.
hol
- 8,255
- 5
- 33
- 59
-
-
This is best answered here: http://stackoverflow.com/questions/869073/what-are-the-pros-cons-of-using-a-synonym-vs-a-view – hol Nov 25 '14 at 15:11