Administrative user accounts have special privileges required to administer areas of the database, such as the CREATE ANY TABLE or ALTER SESSION privilege, or EXECUTE privileges on packages owned by the SYS schema.
dell emc training courses malaysia
The following administrative user accounts are automatically created when Oracle Database is installed:
SYSSYSTEMSYSBACKUPSYSDGSYSKMSYSRAC
CompTIA training courses malaysia
\SYS
When you create an Oracle database, the user SYS is automatically created with all the privileges.
citrix training courses malaysia
All of the base tables and views for the database data dictionary are stored in the schema SYS. These base tables and views are critical for the operation of Oracle Database. To maintain the integrity of the data dictionary, tables in the SYS schema are manipulated only by the database. They should never be modified by any user or database administrator, and no one should create any tables in the schema of user SYS. (However, you can change the storage parameters of the data dictionary settings if necessary.)
Ensure that most database users are never able to connect to Oracle Database using the SYS account.
Leave a Reply