Permission Definition

On OS/400®, database security is managed at the operating system level, not at the database level. When you set up permissions for the database, you determine the degree of access (read, add, delete, etc.) individual users, groups, and authorization lists may have. This operation can easily be done via Operation Navigator.

The privileges must include the following system authorities:

To define a foreign key, the privileges must include the following on the parent table:

The REFERENCES privilege on a table consists of:

The REFERENCES privilege on a column consists of:

To EXECUTE a user-defined function, the privilege consists of: