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 statement 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.