Oracle Database Discussions

Hi Gurus,

I was compiling two procedures using one application user in database. These two procedures are in valid state in production.
I was doing in testing enviornment .
The application user in test env is same as in production withh all proper privileges.

In one procedure script , v$sqltext,v$session and v$process are being used and in other DBA_USERS is being used.
I tried many times for compilation script but error was like table or view is not exist .

But same user was able to query on those views .
To solve the problem , i gave select privilege on v_$<<three >> to application user and then compiled and i was successful.

But my question is user has DBA privilege and able to query on above views but procedure was not created ?