Database Reference
In-Depth Information
Of course, user accounts may be modified or dropped from the system. The
Alter-User
statement allows you to change all the parameters on the
Create-User
statement, but gives the added flexibility of changing some additional settings for the
account. A condensed version of the syntax is shown in Figure
13-7
, which also includes
the syntax for the
Drop-User
statement.
Figure 13-7.
The Alter-User Statement
Note:
1.
You can use this command to assign
roles
to the user account.
We will discuss
roles
shortly.
2.
You can also use the
Proxy-Clause
to grant other privileges to
the user (for more on this, see the Oracle documentation for
the
Alter-User
statement).
3.
The CASCADE option on the
Drop-User
statement drops all
objects owned by the user's schema before dropping the user.
Example 6:
The following statement removes the user called
Bremar
: