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:
Post a Comment