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

From: jacques kostic <jacques.kostic_at_gmail.com>
Date: Fri, 1 Sep 2017 08:02:27 +0200
Message-ID: <CAGLWksob7XzK=g+7PZzLDSgWD-ky=ES67UE=opwMz2H60wXiVA_at_mail.gmail.com>

Also confirmed.

Now with

sqlplus test_42/test_42_at_prod1
SQL> select count (*) from sys.tab$;

Depending on which instance you are connected to, you can have the error immediately.
Jko

Le 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 - 08:02:27 CEST