Shulou(Shulou.com)06/01 Report--

Query the restricted PDB under CDB:

Select con_id, name,open_mode,restricted from v$pdbs

Query the relevant restricted PDB in PDB:

Select instance_name,logins,status from gv$instance (v$containers can also be queried)

Change the pdb restricted mode under cdb:

Alter pluggable database pdb_name close immediate instance=all; (all except pdb1)

Alter pluggable database pdb_name open read write instance=all

Change the pdb restricted mode under pdb:

Alter session set container=pdb_name

Alter pluggable database close immediate

Alter pluggable database open

In restricted mode, specific users can be granted restricted session permissions for temporary login, remember revoke.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.