Oracle数据库用户权限的分配是借助于数据库内部的用户和密码. 也就是说, 在每次连接数据库时, 不是借助于操作系统的用户的密码, 而是用数据库自己提供的用户和密码. 即使你进入操作系统, 没有数据库密码你照样进不去Oracle数据库.
不同权限的用户可以完成不同的数据库操作, 比如数据库的启动与关闭就必须是DBA才可以.
数据库的用户和密码信息在默认情况下是存储在数据字典中的, 但是在大型数据库系统中, 一般情况是将用户密码信息以加密的形式存储在单独的密码文件中, 保存在操作系统的其它地方, 受操作系统的保护.
将密码单独存放在密码文件中的另一个好处是远端装有客户机的机器上不用连接telnet而只通过SQL*Plus而对Oracle数据库进行一切操作, 包括启动, 操作这样的操作.
翻譯（不要GOOGLE翻譯）
2015-05-06 2:54 am
回答 (2)
2015-05-06 8:59 am
✔ 最佳答案
The internal user IDs and passwords in the database are used to help assign the "user privileges" (= rights) of the Oracle database. In other words, it is the user ID (= user name) and password as provided by the database itself that connect you to the database, but not those of the operating system. Without the database password, you cannot get access to the Oracle database even if you have logged into the operation system.Users with different user privileges can perform different database operations, for instance, only DBA (database administrator) can perform the start-up and shutdown of the database.
The information of the database users and passwords is by default stored in the data dictionary. However, in a large scale database system, this information is generally encrypted and saved as a separate password file (= password credentials), which is kept in places other than the database and protected by the operating system.
Another benefit of storing the passwords separately in a password file is enable the remote users to connect with the Oracle database for performing all the operations including the start-up operation, only through SQL * Plus without the need of connecting to telnet.
參考: My own experience as an IT professional
2015-05-06 3:34 am
翻譯為英文
Oracle database user rights assignments were with the database user and password. In other words, every time when connecting to the database, not with the operating system of the user's password, but with the database user and password on your own. Even if you are outside of the operating system, you can go into the Oracle database without a database password.
Privilege allows the user to perform a variety of different database actions, such as startup and shutdown of the database must be a DBA can.
Default database user and password information is stored in the data dictionary, but in large scale database systems, normally the user password information in an encrypted form of the password is stored in a separate file, saved in other parts of the operating system, under the protection of the operating system.
Passwords are stored separately in another benefit of password file is on a remote machine containing the client without connecting Telnet and all operations on Oracle databases only through SQL*Plus, including the initiation, operation such operations.
Oracle database user rights assignments were with the database user and password. In other words, every time when connecting to the database, not with the operating system of the user's password, but with the database user and password on your own. Even if you are outside of the operating system, you can go into the Oracle database without a database password.
Privilege allows the user to perform a variety of different database actions, such as startup and shutdown of the database must be a DBA can.
Default database user and password information is stored in the data dictionary, but in large scale database systems, normally the user password information in an encrypted form of the password is stored in a separate file, saved in other parts of the operating system, under the protection of the operating system.
Passwords are stored separately in another benefit of password file is on a remote machine containing the client without connecting Telnet and all operations on Oracle databases only through SQL*Plus, including the initiation, operation such operations.
收錄日期: 2021-04-11 21:04:27
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20150505000051KK00084