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
joaotellesAsked:
Who is Participating?
 
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
 
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
 
joaotellesAuthor Commented:
Tks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.