I've just imported the production database into another database. After importing my some procedure become invalid. I checked then I saw it was the problem due to some system views like v$session. As there was no grants. Now I've 2 queries.
1. Is grants on system views not imported with other objects, if we are doing full database import with grant=y.
2. How to grant select on system views like v$session to any user. Because I'm facing this problem in granting.
SVRMGR> connect internal
SVRMGR> grant select on v$session to prod;
grant select on v$session to temp
ORA-02030: can only select from fixed tables/views
For temporally, for compiling the procedures, I've given this grant.
SVRMGR> grant select any table to prod;
Thanks & regards