Home » RDBMS Server » Server Administration » grant
grant [message #214683] Wed, 17 January 2007 08:55 Go to next message
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
Re: grant [message #214684 is a reply to message #214683] Wed, 17 January 2007 08:56 Go to previous messageGo to next message
oradba101
Messages: 4
Registered: January 2007
Location: India
Junior Member
try this ..
login as sys
and then say grant select on v_$instance to <user>;

Re: grant [message #214685 is a reply to message #214683] Wed, 17 January 2007 09:01 Go to previous message
plshelp
Messages: 205
Registered: January 2007
Senior Member
thanks it works now.
Previous Topic: external table...
Next Topic: archived generation
Goto Forum:
  


Current Time: Sat Dec 03 13:47:01 CST 2016

Total time taken to generate the page: 0.04282 seconds