Protecting Your Database: Specifying Passwords for Users SYS and SYSTEM (70)

最新推荐文章于 2025-12-18 10:59:28 发布

转载最新推荐文章于 2025-12-18 10:59:28 发布 · 83 阅读

文章标签：

#数据库

本文介绍使用CREATEDATABASE语句创建Oracle数据库时如何为SYS和SYSTEM用户指定密码。如果不指定密码，默认会设置为众所周知的值，存在安全隐患。

The clauses of the CREATE DATABASE statement used for specifying the passwords for
users SYS and SYSTEM are:
■ USER SYS IDENTIFIED BY password
■ USER SYSTEM IDENTIFIED BY password

If you omit these clauses, these users are assigned the default passwords
change_on_install and manager, respectively. A record is written to the alert log
indicating that the default passwords were used. To protect your database, you should
change these passwords using the ALTER USER statement immediately after database
creation.

Oracle strongly recommends that you specify these clauses, even though they are
optional in this release of Oracle Database. The default passwords are commonly
known, and if you neglect to change them later, you leave database vulnerable to
attack by malicious users.

为sys,system用户指定密码
语句分别为 :
user sys identified by
user system identified by

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10599713/viewspace-995631/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10599713/viewspace-995631/