All these options for create user are available in the web-based Oracle Enterprise Manager
interface, as demonstrated in Figure 9-2.
As with any Enterprise Manager operation, the Show SQL button shows the actual SQL
commands, such as create and grant, that will be run when the user is created. This is a great
way to take advantage of the web interface??™s ease of use, while at the same time brushing up
on your SQL command syntax!
In Figure 9-3, you can see that it??™s also very easy to pick an existing user and create a new
user with the same characteristics except for the password.
Other options available in the Enterprise Manager interface include expiring a user account,
generating the DDL used to create the account, and locking or unlocking the account.
Altering Users
Changing the characteristics of a user is accomplished by using the alter user command. The
syntax for alter user is nearly identical to that of create user, except that alter user allows you to
assign roles as well as grant rights to a middle-tier application to perform functions on behalf of
the user.
290 Oracle Database 11g DBA Handbook
FIGURE 9-2 Creating users with Enterprise Manager
FIGURE 9-3 Copying users with Enterprise Manager
Chapter 9: Database Security and Auditing 291
In this example, we??™ll change user SKING to use a different default permanent tablespace:
SQL> alter user sking
2 default tablespace users2
3 quota 500M on users2;
User altered.
Pages:
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490