Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> insufficient priviliges

insufficient priviliges

From: newbie <rjngh2005_at_gmail.com>
Date: 12 Jul 2006 10:20:35 -0700
Message-ID: <1152724835.861861.296740@s13g2000cwa.googlegroups.com>


I have a schema called 'abc'
I do not know the password for the user 'abc'

I know the password for the user 'sys' and user 'system'

I tried the following when logged in as user 'sys' as sysdba and user 'system' and user 'sys' (normal)

select * from abc.pqr where 'pqr' is a table in schema 'abc'

I get the result

However If I create another user 'test' and try the following select * from abc.pqr it gives me the result

ORA-00942: table or view does not exist

I tried the following when I am logged in as user 'sys' as sysdba or sysoper or normal or user system

grant select on abc.pqr to test;

The following is the error message

ORA-01031: insufficient privileges

How do I resolve this...Please help Received on Wed Jul 12 2006 - 12:20:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US