How to decode ace column of table ca_object_ace

Products

• CA Client Automation
• CA Client Automation - IT Client Manager

Issue/Introduction

Permissions of all CA Client Automation objects are stored in table ca_object_ace.

Column ace of this table contains the permission rights value.

What do the different codes mean ? 

 

Example :

Environment

CA Client Automation - All Versions

Resolution

ace value is an integer between 0 and 255

The value is calculated with OR operation of all permissions :

Permission	Value in decimal	Value in binary
No Access	0	00000000
R  Read	1	00000001
W Write	2	00000010
D Delete	4	00000100
P Change Permission	8	00001000
X Execute	16	00010000
O Take Ownership	32	00100000
V View	64	01000000
C Create	128	10000000

 

Example :

RVX permission has value :

00000001 OR 01000000 OR 00010000 = 01010001 = 81

 

In Client Automation there are some predefined permission titles :

Permission title	Value
Read (VR)	65
Manage (VRX)	81
Change (VRWXD)	87
Full Control (CVRWXDPO )	255