Thursday 4 October 2018

PDB DBA user

create user c##dbareadonly identified by urdbapa55 container=all; grant create session to c##dbateam container=all; grant set container to c##dbateam container=all; grant select_catalog_role to c##dbateam container=all; alter user c##dbateam set container_data=all container = current; Above (last line is important, otherwise dba user can't select * from v$pdbs, can't select from pdb views)

No comments: