Message from discussion
insufficient priviliges
Path: g2news2.google.com!postnews.google.com!s13g2000cwa.googlegroups.com!not-for-mail
From: "newbie" <rjngh2...@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: insufficient priviliges
Date: 12 Jul 2006 10:20:35 -0700
Organization: http://groups.google.com
Lines: 30
Message-ID: <1152724835.861861.296740@s13g2000cwa.googlegroups.com>
NNTP-Posting-Host: 207.88.215.14
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1152724841 9044 127.0.0.1 (12 Jul 2006 17:20:41 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 12 Jul 2006 17:20:41 +0000 (UTC)
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.0.3705; .NET CLR 2.0.40607; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: s13g2000cwa.googlegroups.com; posting-host=207.88.215.14;
posting-account=I67nCQ0AAAD0fZgnVHKbMY1Ih0EAsSmN
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