Search notes:

Oracle: User

Connecting to a database

A user must be authenticated by Oracle in order to be able to a database.

Error messages

Error messages that are related to failed attempts to log on the database include
Sometimes, its not even possible to connect to the database because of network problems or wrong configuration. In such a case, the user will receive one of the Oracle net error messages.

Oracle maintained users

Some Oracle maintained users are:
ANONYMOUS
APPQOSSYS
AUDSYS
DBSFWUSER
DBSNMP
DIP
GGSYS
GSMADMIN_INTERNAL Owner of the gsm administrative packages (catgwm.sql)
GSMCATUSER
GSMUSER
ORACLE_OCM
OUTLN
REMOTE_SCHEDULER_AGENT
SYS
SYS$UMF
SYSBACKUP
SYSDG
SYSKM
SYSRAC
SYSTEM
XDB
XS$NULL
This list was created with 
select
   username
from
   dba_users
where
   oracle_maintained = 'Y'
order by
   username

Hardcoded User IDs

$ORACLE_HOME/rdbms/admin/catfusrg.sql mentiones hard coded user ids:

See also

dba_users, all_users, user_users, proxy_users.
A user owns zero, one or more objects.
Proxy users
Selecting the SQL Statements a user has parsed from v$sqlarea allows to get a rough (!) estimation of what a user was doing on a database.
dba_users_with_defpwd lists users that are still using their default passwords.
A user can be assigned a default tablespace.
Each user is assigned a profile which defines some database resource usage limits and constraints related to passwords.
Default roles of a user.
For each tablespace, a certain quota can be defined to the user.
Compiling a user's schema with dbms_utility.compile_schema.
Using the grant SQL statement to give users privileges.
As far as I can tell, there is not hist table for dropped users.
user$

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1788356908, '216.73.217.21', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/users-roles/users/index(136): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78