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’

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: