Database Reference
In-Depth Information
Let us briefly examine each level, and see how they are facilitated in SQL.
For the most part, this is examined in the context of an Oracle environment. However,
the principles covered are also applicable in non-Oracle database environments as well.
13.2.1 Access to the System
Oracle allows access to the system through user profiles and user accounts. A profile is a
working environment for a group of user accounts. When you create a database, Oracle
creates a default profile called DEFAULT. When you create a user account, if you do not
specify a profile, Oracle assigns the DEFAULT profile to the user account. A user account
consists of a user name, a password and other optional parameters. Each user account
has an associated profile.
Figure
13-4
shows the syntax for the Create-Profile statement, and example 4
illustrates how it is used. As can be seen from the syntax, the command is used to help
create a working environment for the user.
Figure 13-4.
The Create-Profile Statement
