Google Mail Calendar Documents Reader Web more »
Recently Visited Groups | Help | Sign in
Google Groups Home
Message from discussion insufficient priviliges

View Parsed - Show only message text

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


Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2009 Google