if you want to view only V$ views then grant create session and select_catalog_role ..

that will do.