[oracle@rac01 ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Apr 17 08:11:46 2023
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> alter session set container=PDB01;

Session altered.

SQL> select username from dba_users where INHERITED='NO';

USERNAME
--------------------------------------------------------------------------------
PDBADMIN

SQL> SELECT username,account_status from dba_users where account_status = 'OPEN' and username not like '%SYS%' and username not like 'C##%' and username not like 'PDBADMIN' and username not like 'DBSNMP';

no rows selected

官方文档:
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/refrn/DBA_USERS.html#GUID-309FCCB2-2E8D-4371-9FC5-7F3B10E2A8C0

版权声明：本文为博主原创文章，未经博主允许不得转载。

oracle