| |
comp.databases.oracle.server |
You have to be connect as "ABC" to grant select abc.X to userY > 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 > 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 > ORA-00942: table or view does not exist > I tried the following when I am logged in as user 'sys' as sysdba or > grant select on abc.pqr to test; > The following is the error message > ORA-01031: insufficient privileges > How do I resolve this...Please help
> I have a schema called 'abc'
> I do not know the password for the user 'abc'
> 'system' and user 'sys' (normal)
> select * from abc.pqr it gives me the result
> sysoper or normal or user system