Toad World® Forums

Rights needed for the toad user


#1

Hello All

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.

Regards
Magnus