HP 3000 Manuals

How Do I Control Database Access? [ Up and Running with ALLBASE/SQL ] MPE/iX 5.0 Documentation


Up and Running with ALLBASE/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 known as 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 command
to give authorities to other users.  The following example grants
permission to update the Employees table to a user known as Henry:

     GRANT UPDATE ON Employees to Henry

The controls you define for database security can be as simple or as
elaborate as you wish.



MPE/iX 5.0 Documentation