Rights needed to read x$ tables
Hi All
The toad user has some views reading from x$ views, I have moved the user to a new database
and have error compiling them. Understandable since I have no rights to read x$ views.
I used dbms_metadata to retrieve the user rights from the old database but it seems those rights
is not included.
I hope I don't need to grant sysdba to the toad user to be able to read them,
or grant rights on the basetables.
What rights do I need to grant to toad to be able to read them ?
Appreciate your comments
Thanks
Magnus