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