• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General

How to grant access to v$ views

How to grant access to v$ views (v$session ,v$instance)

June 15, 2020 by techgoeasy Leave a Comment

One can’t grant direct access V$session as v$session is a synonym. Same is true for v$instance In fact this is true for all the v$ views are they are all synonym’s SQL> GRANT SELECT ON v$session TO test_user; grant select on v$session to test_user * ERROR at line 1: ORA-02030: can only select from fixed […]

Filed Under: Oracle, Oracle Database Tagged With: How to grant access to v$ views

Primary Sidebar



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • How to find weblogic version in Unix & Windows
  • How to use RMAN Catalog Command
  • Oracle drm interview questions
  • How to use RMAN Crosscheck command
  • Oracle Data Relationship Management: Definition, Password , Login

Copyright © 2022 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us