TOAD questions on v$ views
258114Jul 17 2009 — edited Jul 22 2009Hello,
our development would like to optimize some of their statements and is using TOAD to monitor those statements.
TOAD would need read access to dynamic performance views like v$session, v$process, v$sessstat.
We created a role and granted select on following the necessary v$views.
Then we granted the role to a test user, but this user is getting "ORA-00942, table or view does not exist".
Then we granted the select privs on above views directly to the test user and this works, the user can do his monitoring now.
Now I have two questions on that:
1. Does TOAD access these views directly? Or encapsulated, via procedures?
How would I find that out?
-> I am watching TOAD's SQL-Monitor and can see only direct selects, no procedure calls or such.
2. Can I limit the access to this views that way, that user A sees only data of his sessions, and user B only those of her sessions?
My idea would be to create a new set of the necessary v$ views, something like "select whatever from v$session where user=myuser". This would be the let's say: a$views set. Then grant read access to those view set.
What I do not know: How can I tell TOAD to use this "a$" -views instead of the "v$"-views?
3. As far as I remember there was a TOAD configuration item for somewhat like table prefixing or substitution of prefix so-and-so with prefix that-and-that, but I cannot find it now. Maybe someone can give me a hint?
Thanks in advance for any help on the above,
Tajana
Edited by: tajana on Jul 17, 2009 5:53 PM