- 论坛徽章:
- 0
|
问个关于权限设置方面的问题
我把ROOT加入到DBA中也应该继承到属主的权限吧??
照着书上说是该这样的
Using Operating System (OS) Authentication
This section describes how to authenticate an administrator using the operating system.
Preparing to Use OS Authentication
To enable authentication of an administrative user using the operating system you must do the following:
Create an operating system account for the user.
Add the user to the OSDBA or OSOPER operating system defined groups.
Ensure that the initialization parameter, REMOTE_LOGIN_PASSWORDFILE, is set to NONE. This is the default value for this parameter.
************************************************
OSDBA and OSOPER
Two special operating system groups control database administrator connections when using OS authentication. These groups are generically referred to as OSDBA and OSOPER. The groups are created and assigned specific names as part of the database installation process. The specific names vary depending upon your operating system and are listed in the following table:
Operating System Group UNIX Windows
OSDBA dba ORA_DBA
OSOPER oper ORA_OPER
The default names assumed by the Oracle Universal Installer can be overridden. How you create the OSDBA and OSOPER groups is operating system specific.
The following describes how membership in the OSDBA or OSOPER group affects your connection to Oracle:
If you are a member of the OSDBA group, and specify AS SYSDBA when you connect to the database, you are granted the SYSDBA system privilege.
If you are a member of the OSOPER group, and specify AS SYSOPER when you connect to the database, you are granted the SYSOPER system privilege.
If you are not a member of the associated operating system group for SYSDBA or SYSOPER system privileges, the CONNECT command fails. |
|