Object authority

 

There are several types of authority that can be granted to a user for a file. Also, you can use the SQL GRANT and REVOKE statements to assign and remove these i5/OS^® authorities to SQL tables, including individual columns within those tables.

• Object operational authority
  Object operational authority allows you to look at an object description and use the object as determined by your data authorities to the object.

• Object existence authority
  Object existence authority allows you to change the existence status of a file.

• Object management authority
  Object management authority allows you to perform many operations on a file.

• Object reference authority
  Object reference authority allows you to refer to a database file from another database file. The operations that you can perform on the referred-to database file are determined by the referring database file.

• Object alter authority
  Object alter authority allows you to alter the attributes of a database file or SQL package.

 

Parent topic:

Security

 

Related information

SQL Reference