• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 501
  • Last Modified:

Oracle 10g - cant find v$session

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
joaotelles
Asked:
joaotelles
  • 3
  • 2
1 Solution
 
sdstuberCommented:
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
 
joaotellesAuthor Commented:
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
 
joaotellesAuthor Commented:
The second one was because I wasnt as oracle user.
0
 
sdstuberCommented:
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
 
joaotellesAuthor Commented:
Tks
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now