Granting file and data authority

 

DB2 Universal Database™ for iSeries™ provides several methods to grant file and data authority.

• You can use iSeries Navigator to authorize a user or group.

• You can use the Grant Object Authority (GRTOBJAUT) command to specify the authority you want users to have to access data in your database files.

• You can use the SQL GRANT statement.

• Authorizing a user or group using iSeries Navigator
  Some users might need specific authority to an object. You can grant specific authority to a user or group using iSeries Navigator.

• Types of object authority
  An object authority controls what a user can do with an entire object.

• Types of data authority
  A data authority is a specific authority to read, add, update, or delete data in a database file, to run a program, or to search a library or directory.

 

Parent topic:

Securing database files

 

Related reference

Grant Object Authority (GRTOBJAUT) command
GRANT (Table or View Privileges)