You use data control language to determine who has access to
the information in a database. This is very important for security.
Data control language confers authorities on specific users to
perform specific tasks. The most powerful authority is
DBA authority (database administrator authority). The DBECreator,
that is, the person
who creates a new DBEnvironment, automatically has DBA authority in
that DBEnvironment. Someone with DBA authority can then use the
GRANT statement to give authorities to other users.
The following example grants permission to update the Employees
table to a user known as Harry:
GRANT UPDATE ON Employees to Harry
|
The controls you define for database security can be as simple
or as elaborate as you wish.
See Chapter 6, "Practicing with IMAGE/SQL Using MusicDBE," for more
information on database accesses.