Title: RE: Migrating RMAN catalog database to 9.2.0 and supporting 8.0.6
Hi,
I'm
trying to grant SELECT privileges on some tables in schema X to userid Y. I'm
currently connected as SYS. But when I try typing
GRANT
SELECT ON X.MYTABLE TO Y;
...I
get an ORA-01031 error - Insufficient
At 02:49 12/09/2003 -0800, you wrote:
Hi,
I'm trying to grant SELECT
privileges on some tables in schema X to userid Y. I'm currently
connected as SYS. But when I try typing
GRANT SELECT ON X.MYTABLE TO
Y;
...I get an ORA-01031 error -
Insufficient Privileges.
Now I thought SYS had all the
not until the 9i world, you must login as the schema owner or build a
procedure to be able to do it.
joe
Paul Vincent wrote:
Hi,
I'm trying to grant SELECT privileges on some tables in schema X to
userid Y. I'm currently connected as SYS. But when I try typing
GRANT SELECT ON X.MYTABLE TO
Thanks
Bill - not good news, then!
Trouble is, I'm setting up a bunch of "read-only" userids which can see
(but not touch) tables in several other schemas. So instead of doing all the
grants with a single connect (as SYS), evidently I'll have to connect as each
schema-owner in turn, and
ORACLE-L
Subject: Re: Granting object privileges as SYS
At 02:49 12/09/2003 -0800, you
wrote:
Hi,
I'm trying to grant SELECT privileges on some tables in schema X to
userid Y. I'm currently connected as SYS. But when I try typing
GRANT SELECT ON X.MYTABLE TO Y;
...I get an ORA-01031 error