I have moved a toad schema from 10gr2 db to a 11gr2 db. I have problems compiling some views. These views access x$ tables. Normally you only reach those when you have sysdba rights. But I assume the toad user shouldn’t be granted sysdba rights.
Anyone that can tell me what rights I need to grant to be able to compile these views ?
Not sure if it is ok to move a toad user like that between db versions, perhaps a new installations should be done ?
Appreciate your comments.