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@xxxxxxxxxxxx> 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@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@prod1
SQL> select count (*) from sys.tab$;
COUNT(*)
----------
2220
sqlplus test_42/test_42@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