[DQL]User관련 Query Samples

Posted by Alvin You
2014.03.21 11:30 DOCUMENTUM
크리에이티브 커먼즈 라이선스
Creative Commons License
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

 

저작자 표시
신고

'DOCUMENTUM' 카테고리의 다른 글

LDAPSync Mehtod 실행  (0) 2014.03.21
Create Documentum ACL Script  (0) 2014.03.21
EMC HVS(High Volume Server) 성능 테스트  (0) 2014.03.21
[DQL]User관련 Query Samples  (0) 2014.03.21
[DQL]Group 관련 Sample Query  (0) 2014.03.21
[DQL]Object Security 관련 Sample Query  (0) 2014.03.21
Tags
이 댓글을 비밀 댓글로

[DQL]Group 관련 Sample Query

Posted by Alvin You
2014.03.21 11:29 DOCUMENTUM
크리에이티브 커먼즈 라이선스
Creative Commons License

SELECT group_name, group_address, owner_name, group_admin
FROM dm_group
WHERE group_name = 'docu'

SELECT group_name
FROM dm_group WHERE ANY i_all_users_names = 'dmadmin'

SELECT group_name
FROM dm_group
WHERE group_class = 'role'

저작자 표시
신고

'DOCUMENTUM' 카테고리의 다른 글

LDAPSync Mehtod 실행  (0) 2014.03.21
Create Documentum ACL Script  (0) 2014.03.21
EMC HVS(High Volume Server) 성능 테스트  (0) 2014.03.21
[DQL]User관련 Query Samples  (0) 2014.03.21
[DQL]Group 관련 Sample Query  (0) 2014.03.21
[DQL]Object Security 관련 Sample Query  (0) 2014.03.21
Tags
이 댓글을 비밀 댓글로

[DQL]Object Security 관련 Sample Query

Posted by Alvin You
2014.03.21 11:29 DOCUMENTUM
크리에이티브 커먼즈 라이선스
Creative Commons License

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

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

SELECT acl_name, acl_domain
FROM dm_folder
WHERE object_name = 'Temp'

SELECT acl_name, acl_domain
FROM dm_user
WHERE user_name = 'dmadmin'

저작자 표시
신고

'DOCUMENTUM' 카테고리의 다른 글

LDAPSync Mehtod 실행  (0) 2014.03.21
Create Documentum ACL Script  (0) 2014.03.21
EMC HVS(High Volume Server) 성능 테스트  (0) 2014.03.21
[DQL]User관련 Query Samples  (0) 2014.03.21
[DQL]Group 관련 Sample Query  (0) 2014.03.21
[DQL]Object Security 관련 Sample Query  (0) 2014.03.21
Tags
이 댓글을 비밀 댓글로

티스토리 툴바