Try OpenEdge Now
skip to main content
Programming Interfaces
Data Management : ABL API for Multi-tenant and Table Partition Management : Maintaining multi-tenant and table partition entities : Table permissions (reading and updating)
 
Table permissions (reading and updating)
The API provides access to table permissions. The following code shows how to use the API service to read and update table permissions using the ITablePermission interface:
define variable tablePerm as ITablePermission no-undo.

table = service:GetTablePermission("Customer").
/* Set properties */
. . .
service:UpdateTablePermission(tablePerm).
It is also possible to retrieve a collection of tables in the database from the service and then update the Can* properties and multi-tenant related properties in the instances on the ITablePermissionSet collection before passing the collection to the service to commit all changes in a single transaction.
For more information on the:
*ITablePermission entity interface, see ITablePermissioninterface
*ITablePermissionSet entity collection interface, see ITablePermissionSetinterface