grants to roles in PDB
Dear Experts,
I have a PDB and created a readonly user also created a readonly role in the PDB. I have granted select permissions like below. I am not able to fetch rows from the original table to the readonly user . what I am doing wrong?
sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Tue Mar 24 19:38:39 2020
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c EE Extreme Perf Release 12.2.0.1.0 - 64bit Production
SQL> alter session set container = devp;
Session altered.
SQL> create user readonlytest identified by *** container = current;
User created.
SQL> create role readonlyrole container=current;
Role created.