Groups and Roles

- Groups

每个用户都可分配给下列权限：None (no special privileges)、Create Type (can create object types)、Create Cabinet (can create cabinets)、Create Group (can create groups)、Sysadmin (system administration privileges)

- Creating Groups

Ø Use DQL:create dm_group object set group_name = ‘testgroup2’

Ø Use API:create,c,dm_group

Set,c,l,group_name testgroup1

Save,c,l

- Roles

Ø Roles are defined in Content Server 5.1 and above as a special type of group.Goup的 group_class属性被设置成‘role’,group_name属性被设置成role的名字

Ø Capability 是可累积的，如果一个user role可以实现某种操作，那比它更高级别的role也可以实现此操作

- Creating Roles

Use DQL:create dm_group object set group_class = ‘role’,set group_name = ‘dqlrole1’

Use API:create,c,dm_group

Set,c,l,group_class role

Set,c,l,group_name apirole1

Save,c,l

- Useful DQL Queries

1. Get current session:execute show_session

2. Get current date, time:select DATE(now) as systime from dm_server_config;

3. 重复属性作为where的查询条件时属性名前面应有any，否则出错

4. Retrieve all required attributes of a particular type：
SELECT attr_name FROM dmi_dd_attr_info WHERE type_name=’dm_document’ AND is_required <> 0

5. DQL hints

SELECT object_name FROM dm_document ENABLE (RETURN_TOP 10)

6. List docbrokers:execute list_targets

7. To deal with apostrophes in DQL, escape with apsotrophe. For example to find all users with name like O’Hare, use following DQLselect group_name from dm_group where any users_names like ‘% O”Hare%’