Useful DQL Queries: Object Security

Display the folder security settings 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 =
‘internal_reviewers’ and acl_domain = ‘dsmith’

List the permission sets that specifically reference this user:

select object_name, owner_name from dm_acl where
any r_accessor_name = ‘fred’


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: