How to grant V$session Priviledge to Scott User

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

Hi,

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

Code:

---

grant select on sys.v_$session to scott;

---

Regards,
Nir