Database Administration (MOSC)

MOSC Banner

grants to roles in PDB

edited Apr 7, 2020 10:53AM in Database Administration (MOSC) 9 commentsAnswered

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center