grant select any table privilege to that user.

The user can access v$tables and also dba_ tables.

Thanks,