(private) sorry...!! contact@ecmnotes.com

Object security (ACL)

Display the folder security setting for this repository (0=disabled, 1=enabled):

SELECT folder_security FROM dm_docbase_config

 Show the default ACL mode for the Content Server:

SELECT default_acl FROM dm_server_config

List the objects associated with this permission set:

SELECT object_name FROM dm_sysobject WHERE acl_name = '' and acl_domain = ''

List the permission sets that specifically reference this user:

SELECT object_name, owner_name FROM dm_acl WHERE any r_accessor_name = ''

To set ACL of home cabinet of all newly created users:

update dm_cabinet objects set acl_name=’’ set acl_domain=’’ Where acl_name not like '' and object_name in (select user_login_name from dm_user where user_name not in ('dm_bof_registry','temp'))

Returns a list of the object_name and all users which may access the acl if they are in the group

SELECT object_name, r_accessor_name FROM dm_acl WHERE any r_accessor_name IN (select group_name from dm_group) ORDER by r_accessor_name

Returns object_name of the acl for a particular group

SELECT object_name FROM dm_acl WHERE any r_accessor_name IN (select group_name from dm_group) AND ANY r_accessor_name = 'group_name'

Set ACL of all the documents in a folder:

Update dm_sysobject objects set acl_name='ACL_NAME' set acl_domain='' where folder('/A/B/C',descend)

Get the list of folders to which a particular folder has write permission:

select * from dm_folder where acl_name IN (select object_name from dm_acl where any r_accessor_name = 'group_name' and any r_accessor_permit = '6')

Retrieve the ACL set on the inner folder:

select object_name, r_accessor_name, r_accessor_permit from dm_acl where object_name in (select distinct acl_name from dm_folder where folder ('/A/A', descend) order by object_name)


Leave a Reply