how to disable v$session functionality ?

babloosony · #1 (**permalink**) 03-03-03, 06:31

Hi All,

Whenever a client connects to oracle, a row is inserted into v$session object that contains specific information
of the client. How can I disable this feature ....

Thanks & Regards,
Kumar.

andrewst · #2 (**permalink**) 03-03-03, 06:48

I don't think you can. Why on Earth would you want to do that anyway?

babloosony · #3 (**permalink**) 03-03-03, 06:51

it is one way of learning how a cracking/hacking works on the database ...

andrewst · #4 (**permalink**) 03-03-03, 07:21

Quote:

Originally posted by babloosony
it is one way of learning how a cracking/hacking works on the database ...

Well, I don't know anything about how such hacking might work, but presumably you can just REVOKE SELECT ON v$session FROM the users/roles?

Internet Services

Web Development

Digital Marketing

Consumer Tech