Oracle Database Discussions

Hi there,

I created a new user account and granted it dba.
I logged on to this account and I am trying to run select statments on V$SQLAREA, V$SQL, V$SQLTEXT, and V$SQL_PLAN, but I am getting

ORA-00942: table or view does not exist
00942. 00000 - "table or view does not exist"

However, I can get into these views with SYSTEM.

I loged into system and tried to grant

grant select on V$SQLTEXT to user_name;

SQL Error: ORA-01031: insufficient privileges
01031. 00000 - "insufficient privileges"
*Cause: An attempt was made to change the current username or password
without the appropriate privilege. This error also occurs if
attempting to install a database without the necessary operating
system privileges.

now, I know i'm not trying to change password nor attempting to instal new database.

I am runnning Oracle XE and the views are


OBJECT_NAME OBJECT_TYPE STATUS OWNER STATUS
------------------------------ ------------------- ------- ------------------------------ -------
V$SQL_PLAN SYNONYM VALID PUBLIC VALID
V$SQLAREA SYNONYM VALID PUBLIC VALID
V$SQLTEXT SYNONYM VALID PUBLIC VALID
V$SQL SYNONYM VALID PUBLIC VALID


Where is the problem?

Thanks in advance for any effort