Hello all
anyone knows how to delete an ACL Template? It is not possible to do it by DA...
Thank you
You can delete the ACL Template using DQL or API. But before that, make sure that no objects in the repsitory are using this acl.
You can use the following query to check that. The acl_class attribute defines the class of acl (public, private, template), acl_class 2 represents the acl template instance. Refer to the object ref guide more details.
DQL>select * from dm_sysobject where acl_name in (select object_name from dm_acl where acl_class = 2);
If the above query returns any rows than update those objects with a different acl.
DQL>update dm_sysobject object set acl_name = '<ACLName>', set acl_domain = 'dm_dbo'
where object_name in (select object_name from dm_sysobject
where acl_name in (select object_name from dm_acl where acl_class = 2);
Finally, you can blow your acl template out of the water, by using a simple API. Get the r_object_id of your acl template using the API below
API>destroy,c,Obj_ID_of_ACL
