12.2 RAC: grant visible on one node only?
From: vit\.spinka <vit.spinka_at_vitspinka.cz>
Date: Fri, 1 Sep 2017 04:16:43 +0200
Message-Id: <OVKWZV$3B9E95B0994CEE66BD90EBD934BD4738_at_vitspinka.cz>
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
Date: Fri, 1 Sep 2017 04:16:43 +0200
Message-Id: <OVKWZV$3B9E95B0994CEE66BD90EBD934BD4738_at_vitspinka.cz>
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-lReceived on Fri Sep 01 2017 - 04:16:43 CEST