Title: normal user obtaining program info?
Hello Gurus,
I would like to try and build in some security onto a certain schemas tables, using for instance from system, I can do a select from v$session to obtain program name etc. ie,
SELECT PROGRAM FROM V$SESSION;
An extention
Hi Eva
Have a look at VPD (Virtual Privet Database) and FGA Fine Grained
Access) in the manual
Denham Eva wrote:
Hello Gurus,
I would like to try and build in some security onto a certain schemas
tables, using for instance from system, I can do a select from
v$session to obtain program
As SYS,
create view MY_SESSION as
SELECT ... FROM V$SESSION
WHERE SID IN (SELECT SID FROM V$MYSTAT);
grant select on MY_SESSION to public
create public synonym ...
hth
connor
--- Denham Eva [EMAIL PROTECTED] wrote: Hello
Gurus,
I would like to try and build in some security onto
a