News
Abstract
The OBJECT_PRIVILEGES view returns a row for every user authorized to an object, along with their associated object and data authorities.
The information returned is similar to the information available through the Display Object Authority (DSPOBJAUT) CL command.
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > IBM i Services (SQL) > QSYS2.OBJECT_PRIVILEGES
For complete detail, visit this IBM Knowledge Center page: OBJECT_PRIVILEGES_INFO view
Enhanced with IBM i 7.4 SF99704 Level 7 and IBM i 7.3 SF99703 Level 18:
- Add Authorization list management (AUTHORIZATION_LIST_MANAGEMENT) and Object owner (OBJECT_OWNER) columns
Enhanced with IBM i 7.4 SF99704 Level 4 and IBM i 7.3 SF99703 Level 16:
- Add Primary Group (PRIMARY_GROUP) column
Enhanced with IBM i 7.4 base release and IBM i 7.3 SF99703 Level 15:
- AUTHORIZATION_LIST was added to the VIEW
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]
Was this topic helpful?
Document Information
Modified date:
11 April 2020
UID
ibm11127157