santhoshreddy podduturi, November 03, 2016 - 8:06 am UTC
Hi Conor,
Please dont think that i am gonna waste your time to read my story.Acutally i am a oracle begineer also new to data base technologies.My intension is to know the logic behind the DataBases working.I want to have knowledge on oracle like you,so iam exploring for logics and startegies behind the oracle data base working but every one saying different logics different strategies.
For example i asked the question for reason behind the creating synonyms views for system tables.all people around me said to protect the tables from ddl commands like drop table alter table.but iam not satisfied with that answer because we can know the source code of views and synonyms by so many tools.you explained the reason iam satisfied with that,but still i have the doubt really,Can we protect them(system tables of dictionary views) by using views and synonyms?
November 04, 2016 - 2:42 am UTC
"Can we protect them(system tables of dictionary views) by using views and synonyms? "
Yes, because no-one logs on to the SYS schema (or shouldnt be) in normal operations. Thus you will see that the base tables not accessible to anyone, but the views on top of them *are* accessible (via grants).
So views are a means of encapsulating information, and grants on those views, provide a nice security layer on top of that
santhoshreddy podduturi, November 04, 2016 - 3:50 am UTC
Thank you So much Conor