Documentum 6.5 Content Management Foundations by Unknown

Author:Unknown
Language: eng
Format: mobi, epub
Publisher: Packt Publishing

Help—some DQL queries

Some helpful queries related to object security are described in this section. These queries are based on the information presented in this chapter.

The following query retrieves basic permissions granted on a given object:

SELECT r_accessor_name, r_accessor_permit FROM dm_acl WHERE object_name = (SELECT acl_name FROM dm_document WHERE r_object_id = '0900006480000509') AND owner_name = (SELECT acl_domain FROM dm_document WHERE r_object_id = '0900006480000509')

Note a few things in this query. DQL doesn't allow joins when retrieving repeating properties (accessor name and permit) – this query achieves the same effect using sub-queries. Also note that both acl_name and acl_domain should be checked when looking up the ACL for an object.

It is not straightforward to check extended permissions through queries since they return an integer value that needs to be decoded. However, this value can be decoded using the information provided in the chapter. It is best to view extended permissions through an application such as Webtop or Documentum Administrator.

The following query retrieves the default ACL for the type dm_document:

SELECT acl_name, acl_domain FROM dmi_type_info WHERE r_type_name = 'dm_document'

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.