Oracle 10g - cant find v$session

joaotelles
joaotelles used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2011
Top Expert 2012

Commented:
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"

Author

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?

Author

Commented:
The second one was because I wasnt as oracle user.
Most Valuable Expert 2011
Top Expert 2012
Commented:
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;

Author

Commented:
Tks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial