<div>
your dbg_a &nbsp;user doesn't have permissions on those views<br />
<br />
<br />
grant select on each of them as SYS<br />
<br />
or, if you'll need other dictionary access, &nbsp;consider &nbsp;&quot;select any dictionary&quot;
</div>


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"

<div>
Im getting this:<br />
<br />
SQL&gt; grant select v$session as SYS;<br />
grant select v$session as SYS<br />
&nbsp; &nbsp; &nbsp; *<br />
ERROR at line 1:<br />
ORA-00990: missing or invalid privilege<br />
<br />
Also:<br />
grant select on v$session to sasa;<br />
SQL&gt; connect / as sysdba<br />
ERROR:<br />
ORA-01031: insufficient privileges<br />
<br />
<br />
Any suggestion?<br />

</div>


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?


<div>
The second one was because I wasnt as oracle user.
</div>


The second one was because I wasnt as oracle user.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Im logging at the Db using a user dbg_a and it does not have the views:<br />
<br />
v$parameter<br />
v$session<br />
<br />
Can them be created manually?<br />
<br />
They are there as system user...<br />
<br />
Tks,<br />
Joao
</div>
</div>


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

Oracle 10g - cant find v$session

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.