How to grant V$session Priviledge to Scott User

[hirani_prashant]

Hello,

How can we able to grant V$session priviledges to application user.

For example, i want to grant v$session priviledge to user scott then wt should i have to do?

-Thanks
Prashant

[nir_s]

Hi,

Connect as user sys or any OS user with sysdba privileges and run the following command:

grant select on sys.v_$session to scott;

Regards,
Nir