[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Oracle 10g - cant find v$session

Posted on 2011-09-02
5
Medium Priority
?
491 Views
Last Modified: 2012-05-12
Hi,

Im logging at the Db using a user dbg_a and it does not have the views:

v$parameter
v$session

Can them be created manually?

They are there as system user...

Tks,
Joao
0
Comment
Question by:joaotelles
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 74

Expert Comment

by:sdstuber
ID: 36472873
your dbg_a  user doesn't have permissions on those views


grant select on each of them as SYS

or, if you'll need other dictionary access,  consider  "select any dictionary"
0
 

Author Comment

by:joaotelles
ID: 36472915
Im getting this:

SQL> grant select v$session as SYS;
grant select v$session as SYS
      *
ERROR at line 1:
ORA-00990: missing or invalid privilege

Also:
grant select on v$session to sasa;
SQL> connect / as sysdba
ERROR:
ORA-01031: insufficient privileges


Any suggestion?
0
 

Author Comment

by:joaotelles
ID: 36472926
The second one was because I wasnt as oracle user.
0
 
LVL 74

Accepted Solution

by:
sdstuber earned 2000 total points
ID: 36472948
you must login as SYS  (system or other dba users can't grant on SYS objects, unless they have the "WITH GRANT OPTION", which most users do not)

also, the  real view names have an underscore in them,

so....


grant select on v_$session to dbg_a;
grant select on v_$parameter to dbg_a;
0
 

Author Closing Comment

by:joaotelles
ID: 36473010
Tks
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question