查找Oracle数据库非默认用户

查找Oracle数据库非默认用户

𝓓𝓸𝓷 Lv6
  2026-08-20 16:49:33 2026-08-20 16:49:33 Created   2026-08-20 16:49:29 2026-08-20 16:49:29 Updated    

查看Oracle数据库默认用户、默认帐号、系统自带用户、系统内置用户、数据库内置帐号、数据库默认用户

一、通过created字段查找

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
 set linesize 200 pagesize 200
 col uesrname for a40
select created,username from dba_users order by 1;

CREATED 	    USERNAME
------------------- --------------------------------------------------------------------------------------------------------------------------------
2021-09-29 17:09:49 SYSBACKUP
2021-09-29 17:09:49 OUTLN
2021-09-29 17:09:49 SYSTEM
2021-09-29 17:09:49 SYSKM
2021-09-29 17:09:49 SYS
2021-09-29 17:09:49 AUDSYS
2021-09-29 17:09:49 SYSDG
2021-09-29 17:11:03 GSMUSER
2021-09-29 17:11:03 GSMADMIN_INTERNAL
2021-09-29 17:11:06 DIP
2021-09-29 17:11:24 XS$NULL
2021-09-29 17:11:33 ORACLE_OCM
2021-09-29 17:15:08 DBSNMP
2021-09-29 17:15:09 APPQOSSYS
2021-09-29 17:15:12 XDB
2021-09-29 17:15:12 ANONYMOUS
2021-09-29 17:16:45 GSMCATUSER
2021-09-29 17:16:53 WMSYS
2021-09-29 17:17:36 OJVMSYS
2021-09-29 17:18:23 CTXSYS
2021-09-29 17:18:39 SI_INFORMTN_SCHEMA
2021-09-29 17:18:39 ORDDATA
2021-09-29 17:18:39 MDSYS
2021-09-29 17:18:39 ORDPLUGINS
2021-09-29 17:18:39 ORDSYS
2021-09-29 17:21:12 OLAPSYS
2021-09-29 17:21:16 MDDATA
2021-09-29 17:22:51 SPATIAL_WFS_ADMIN_USR
2021-09-29 17:22:54 SPATIAL_CSW_ADMIN_USR
2021-09-29 17:23:11 APEX_PUBLIC_USER
2021-09-29 17:23:11 APEX_040200
2021-09-29 17:23:11 FLOWS_FILES
2021-10-15 16:50:13 SCOTT
2021-10-15 16:50:13 ECONSTAT
2021-10-15 16:50:14 EQUIPMENT
2021-10-15 16:50:14 TJHISRPT
2021-10-15 16:50:14 EXAM
2021-10-15 16:50:14 TJ

二、通过INHERITED字段查找

Oracle12c 12.2版本可以通过INHERITED字段区分是否为内置用户

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
SQL> select username from dba_users where INHERITED='YES';

USERNAME
--------------------------------------------------------------------------------
SYS
SYSTEM
XS$NULL
SYSBACKUP
SYSRAC
SYSKM
OUTLN
SYS$UMF
SYSDG
DBSNMP
APPQOSSYS
DBSFWUSER
GGSYS
ANONYMOUS
GSMADMIN_INTERNAL
XDB
WMSYS
GSMCATUSER
REMOTE_SCHEDULER_AGENT
C##CLONE
GSMUSER
C##TS
AUDSYS
DIP
ORACLE_OCM

三、查询Oracle数据库非内置帐号

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
select username
  from dba_users
 where username not in ('SCOTT',
                        'ORACLE_OCM',
                        'OJVMSYS',
                        'SYSKM',
                        'XS$NULL',
                        'GSMCATUSER',
                        'MDDATA',
                        'SYSBACKUP',
                        'DIP',
                        'SYSDG',
                        'APEX_PUBLIC_USER',
                        'SPATIAL_CSW_ADMIN_USR',
                        'SPATIAL_WFS_ADMIN_USR',
                        'GSMUSER',
                        'C##TS',
                        'AUDSYS',
                        'FLOWS_FILES',
                        'DVF',
                        'MDSYS',
                        'ORDSYS',
                        'DBSNMP',
                        'WMSYS',
                        'APEX_040200',
                        'APPQOSSYS',
                        'GSMADMIN_INTERNAL',
                        'ORDDATA',
                        'CTXSYS',
                        'ANONYMOUS',
                        'XDB',
                        'ORDPLUGINS',
                        'DVSYS',
                        'SI_INFORMTN_SCHEMA',
                        'OLAPSYS',
                        'LBACSYS',
                        'EXFSYS',
                        'OUTLN',
                        'XS$NULL',
                        'OWBSYS',
                        'OWBSYS_AUDIT',
                        'MGMT_VIEW',
                        'DBSFWUSER',
                        'GGSYS',
                        'REMOTE_SCHEDULER_AGENT',
                        'C##CLONE',
                        'SYSRAC',
                        'GSMROOTUSER',
                        'SYS$UMF',
                        'APEX_030200',
                        'PDB_ADM',
                        'PDBADM',
                        'PDB_ADMIN',
                        'FLOWS_030000',
                        'SOLWIN',
                        'SQLTXPLAIN',
                        'SYS$UMF',
                        'APEX_050000',
                        'APEX_050100',
                        'APEX_INSTANCE_ADMIN_USER',
                        'PDBADMIN',
                        'SYSMAN',
                        'SYSTEM',
                        'SYS');
  • Title: 查找Oracle数据库非默认用户
  • Author: 𝓓𝓸𝓷
  • Created at : 2026-08-20 16:49:33
  • Updated at : 2026-08-20 16:49:29
  • Link: https://www.zhangdong.me/oracle-database-non-default-users.html
  • License: This work is licensed under CC BY-NC-SA 4.0.
推荐文章
Oracle数据库默认用户名 Oracle数据库默认用户名 ORA-01775: looping chain of synonyms ORA-01775: looping chain of synonyms 查看Oracle帐号被锁原因及查看Oracle用户登录失败次数 查看Oracle帐号被锁原因及查看Oracle用户登录失败次数
推荐文章
Oracle数据库默认用户名 Oracle数据库默认用户名 ORA-01775: looping chain of synonyms ORA-01775: looping chain of synonyms
评论
  1. 一、通过created字段查找
  2. 二、通过INHERITED字段查找
  3. 三、查询Oracle数据库非内置帐号