Our Data Base Administrator doesn't give us the GRANT to SELECT from V$ Oracle system views, for example V$SQLAREA, V$SESSION, and so on.
Is there a valid reason for this, in your opinion?
Granting select from V$ views could be dangerous?
Could it expose the database to vulnerabilities?
Thank you very much for considering my request.
Some DBAs are just control freaks :)
Having said which, it is true that SQL text in live environments could contain sensitive data in the WHERE clause, so it is more understandable for certain views in UAT and PRODUCTION. But a blanket ban is just lazy.
The nub is, why do you need access to the V$ views? If you're being asked to investigate problems in live environments relating to performance, locking and so forth you need to query those views. So get your boss involved and make a case for sensible access to the views you need, fitting within any data governance (or other valid) concerns.