Database Reference
In-Depth Information
In addition to profiles, Oracle allows the DBA (or some user with system admin
privileges) to create and remove users accounts. Each user account is assigned to a
profile. If the profile is not specified at account creation, Oracle assigns the account to the
DEFAULT profile. The required syntax for the Create-User statement follows:
Figure 13-6. The Create-User Statement
Note:
1.
Oracle supports a local database user, a global user
(authenticated by Enterprise Directory Service), or an external
operating system user.
2.
To activate the password expiration (defined in the user's
assigned profile), specify PASSWORD EXPIRE.
3.
Use the ACCOUNT LOCK / UNLOCK option to lock the
account (make it inaccessible by the user) or unlock the
account.
4.
When you create a user, Oracle creates a schema by the same
name as the user. All objects created by that user will be
owned by the user's schema.
Example 5: The following statement creates a user called Bremar .
 
Search WWH ::




Custom Search