Message from discussion
insufficient priviliges
Path: g2news2.google.com!postnews.google.com!m79g2000cwm.googlegroups.com!not-for-mail
From: "franck" <francois.bourda...@harfan.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: insufficient priviliges
Date: 12 Jul 2006 10:32:37 -0700
Organization: http://groups.google.com
Lines: 34
Message-ID: <1152725557.675348.304650@m79g2000cwm.googlegroups.com>
References: <1152724835.861861.296740@s13g2000cwa.googlegroups.com>
NNTP-Posting-Host: 206.162.131.219
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1152725562 4688 127.0.0.1 (12 Jul 2006 17:32:42 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 12 Jul 2006 17:32:42 +0000 (UTC)
In-Reply-To: <1152724835.861861.296740@s13g2000cwa.googlegroups.com>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: m79g2000cwm.googlegroups.com; posting-host=206.162.131.219;
posting-account=R_Z1uAwAAAAssd1YApkLubN0Dgc_1hlH
You have to be connect as "ABC" to grant select abc.X to userY
newbie wrote:
> 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
|
