HP 3000 Manuals

Getting Started with HP IMAGE/SQL

How Do I Control Database Access? 

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.

MPE/iX 5.0 Documentation