Hi,
like this one ?
create view SYS.v_$mysession as select * from v$session where username=user;
create public synonym v$mysession for SYS.v_$mysession;
grant select on SYS.v_$mysession to public;
create user test identified by test;
grant create session to test;
connect test/test
select sid,serial#,username from v$mysession;
SID SERIAL# USERNAME
---------- ---------- ------------------------------
258 29382 TEST
Best Regards,
Oleksandr Denysenko
29.03.2019 15:26, Luis Santos пишет:
Is there a way to hack the V$MYSTAT definition to create a "V$MYSESSION", which would contain a subset from V$SESSION relative to the current_user (current and possibly other sessions from the same user)?
/--/
/Best regards/
/Luis Santos
/
/
/