OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » grant

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

grant [message #214683]

Wed, 17 January 2007 08:55

plshelp
Messages: 205
Registered: January 2007

Senior Member

HI,

When I log into Sql*plus as sys user
and execute the below statement:

select * from v$instance;

It works.

But when i log in as schema user erisp

SQL> select * from v$instance;
select * from v$instance
*
ERROR at line 1:
ORA-00942: table or view does not exist

Please help me what grant i should give to this user to execute this. Thanks very much

Report message to a moderator