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
Received on Wed Jul 12 2006 - 12:32:37 CDT
