Re: 12.2 RAC: grant visible on one node only?

From: Franck Pachot <franck_at_pachot.net>
Date: Fri, 01 Sep 2017 05:02:56 +0000
Message-ID: <CAK6ito1_kr2sp-7i9mFos5uDSBb0wUkp1CdESNTPf6U1xCYUeQ_at_mail.gmail.com>



Hi Vit.
I see the same. And if I select before the grant (ORA-942) I have to flush the shared pool after the grant to see it again. The non-existence of the object is not invalidated in other instances when we grant. Franck

Le ven. 1 sept. 2017 à 04:17, vit.spinka <vit.spinka_at_vitspinka.cz> a écrit :

> Hi all,
> have you ever seen anything like this?
>
> This is a 12.2.0.1 installation, Linux 64-bit, 2-node RAC, no patches
> applied. Multitenant database.
>
> One node node, I create a user and grant it select on a sys table. I can
> connect as this user to either of the nodes; however, only one the first
> node (where the grant was made) I can select from that table. On the other
> node, I don't seem to have the privileges granted.
>
> sqlplus sys_at_prod1 as sysdba
> create user test_42 identified by test_42;
> grant create session to test_42;
> grant select, flashback on sys.tab$ to test_42;
>
> Then try it out:
>
> sqlplus test_42/test_42_at_prod1
> SQL> select count (*) from sys.tab$;
>
> COUNT(*)
> ----------
> 2220
>
> sqlplus test_42/test_42_at_prod2
> SQL> select count (*) from sys.tab$;
> select count (*) from sys.tab$
> *
> ERROR at line 1:
> ORA-00942: table or view does not exist
>
> I guess it's a bug, but my Metalink skills seem weak today and I could not
> find any matching document/bug.
>
>
> Vit
>

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Sep 01 2017 - 07:02:56 CEST

Original text of this message