Also confirmed.
Now with
sqlplus test_42/test_42@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@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