insufficient priviliges - comp.databases.oracle.server

Message from discussion insufficient priviliges

franck

More options 12 July 2006, 18:32

Newsgroups: comp.databases.oracle.server

From: "franck" <francois.bourda...@harfan.com>

Date: 12 Jul 2006 10:32:37 -0700

Local: Wed 12 July 2006 18:32

Subject: Re: insufficient priviliges

  Reply to author
  |
  Forward | Print | View thread
  | Show original
  | Report this message | Find messages by this author
  

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

Reply to author Forward