Managing Users教学文稿.ppt

How to Use Oracle Enterprise Manager to Create a New User Launch the Console %oemapp console Choose to Launch standalone You can also launch the Console from Windows NT Start menu. Expand your working database from the databases folder Expand the Security folder Select the Users folder and select Create from the right mouse menu. Enter user information in the General page of the property sheet. Specify quotas using the Quotas page. Click Create. You can also select a user and then select Object—Create Like from the menu bar to create a user with the same quotas and privileges as an existing database user. Oracle Security Manager automatically grants the CONNECT role to any user who is created using the tool. Note: Refer to the Managing Roles lesson for information on the CONNECT role. OS Authenitication Operating System Authentication Use the IDENTIFIED EXTERNALLY clause of the CREATE USER command to specify that a user must be authenticated by the operating system. This option is generally useful when the user logs on directly to the machine where the Oracle server is running. Username for Operating System Authentication The OS_AUTHENT_PREFIX initialization parameter is used to specify the format of the usernames for operating system authentication. This value defaults to OPS$ to make it backward compatible with earlier releases of the Oracle server. To set the prefix to a NULL value, specify this initialization parameter as: OS_AUTHENT_PREFIX = ““ The example in the slide shows how a user, aaron, is defined in the database. This specifies that the operating system user aaron will be allowed access to the database without having to go through any validation by the Oracle server. Thus, to use SQL Plus to log on to the system UNIX user aaron needs to enter the following command from the operating system: $ sqlplus / Username for Operating System Authentication (continued) Note Using OS_AUTHENT_PREFIX=OPS$ gives the flexibility of having a user authenticate