Thursday, December 11, 2008

[DQL]User관련 Query Samples

Documentum Query Language 중 User 생성과 관련된 Sample Query

#사용자별 문서 등록 현황
SELECT owner_name, count(*)
FROM dm_sysobject
WHERE r_object_id like '09%'
GROUP BY owner_name


# User 관 련 Sample Querys
SELECT user_name, user_login_name, user_address, description, home_docbase, user_state
FROM dm_user
WHERE user_login_name = 'gildong'

CREATE dm_user object
SET user_name = 'Gil-Dong',
SET user_login_name = 'gildong',
SET user_address = 'gildong@help.me',
SET user_group_name = 'docu',
SET user_source = 'inline password',
SET user_privileges = 2,
SET client_capability = 4

CREATE dm_folder object
SET object_name = 'gildong',
SET owner_name = 'Gil-Dong'

UPDATE dm_user objects
SET default_folder = 'Cabinet/gildong'
WHERE user_login_name = 'gildong'

#lists the inactive users in repository
SELECT user_name, user_login_name
FROM dm_user
WHERE user_state = 1 OR user_state = 3

SELECT user_name, user_privileges, user_xprivileges
FROM dm_user
WHERE user_login_name = 'gildong'

#LDAP 설정 정보 조회
SELECT object_name
FROM dm_ldap_config

No comments: