以下為Oracle原廠文件所提到的帳號清單, locked 代表一般安裝好的資料庫中，是停用的。
account
|
Usage
|
Account Status
|
ANONYMOUS
|
Oracle XML DB
|
Expired and locked
|
CTXSYS
|
Oracle Text
|
Expired and locked
|
DBSNMP
|
Oracle Enterprise Manager
|
Open
|
EXFSYS
|
Rules Manager and Expression Filter
|
Expired and locked
|
LBACSYS
|
Oracle Label Security
|
Expired and locked
|
MDSYS
|
Oracle Spatial and Oracle Multimedia Locator administrator account
|
Expired and locked
|
MGMT_VIEW
|
Oracle Enterprise Manager
|
Open
|
OLAPSYS
|
OLAP Catalog
|
Expired and locked
|
ORDDATA
|
Oracle Multimedia DICOM data model
|
Expired and locked
|
OWBSYS
|
Oracle Warehouse Builder repository
|
Expired and locked
|
ORDPLUGINS
|
Oracle Multimedia
|
Expired and locked
|
ORDSYS
|
Oracle Multimedia administrator
|
Expired and locked
|
OUTLN
|
Plan stability account
|
Expired and locked
|
SI_INFORMTN_SCHEMA
|
Views for the SQL/MM Still Image Standard
|
Expired and locked
|
SYSMAN
|
Oracle Enterprise Manager
|
Open
|
TSMSYS
|
transparent session migration (TSM)
|
Expired and locked
|
WK_TEST
|
Oracle Ultra Search
|
Expired and locked
|
WKSYS
|
Ultra Search database super-user
|
Expired and locked
|
WKPROXY
|
Oracle9i Application Server Ultra Search
|
Expired and locked
|
WMSYS
|
Oracle XML DB data and metadata
|
Expired and locked
|
BI
|
Default Sample Schema
|
Expired and locked
|
HR
|
Default Sample Schema
|
Expired and locked
|
OE
|
Default Sample Schema
|
Expired and locked
|
PM
|
Default Sample Schema
|
Expired and locked
|
IX
|
Default Sample Schema
|
Expired and locked
|
SH
|
Default Sample Schema
|
Expired and locked
|
SYSTEM
|
資料庫管理帳號SYSPOER
|
Open
|
SYS
|
資料庫管理帳號SYSDBA
|
Open
|
查詢Oracle帳號方法如下:
As Oracle User
sqlplus "/ as sysdba"
SQL>
col username for a25
col account_status for a8
col default_tablespace for a10
select username , account_status , created , default_tablespace from dba_users where account_status not like '%LOCKED%' order by username;
USERNAME ACCOUNT_ CREATED DEFAULT_TA
------------------------- -------- ------------------ ----------
DBSNMP OPEN 04-FEB-10 SYSAUX => 資料庫Oracle OEM (內部使用)
HR OPEN 22-APR-11 USERS
RPT OPEN 25-JUL-12 USERS
SYS OPEN 04-FEB-10 SYSTEM => 資料庫管理帳號 SYSDBA
SYSMAN OPEN 04-FEB-10 SYSAUX => 資料庫管理帳號 SYSOPER
SYSTEM OPEN 04-FEB-10 SYSTEM
TEST OPEN 20-JUL-11 USERS
7 rows selected.
排除預設帳號, 黃字部分為有使用的三個Oracle帳號：
HR, RPT, TEST
若確定TEST帳號沒在使用, 可以將其LOCKED
SQL>
alter user test account lock;
User altered.
查詢TEST帳號, 可以發現TEST帳號已經停止使用(LOCKED)
col username for a25
col account_status for a8
col default_tablespace for a10
select username , account_status , created , default_tablespace from dba_users where username='TEST';
沒有留言:
張貼留言