Help—Some DQL Queries

Here are some helpful queries related to users. These queries are based on the information presented in this chapter.

The following query retrieves some basic information about a user with login name jdoe:

SELECT user_name, user_login_name, user_address, description,
home_docbase, user_state
FROM dm_user
WHERE user_login_name = 'jdoe'

The following queries set up a new user named Jane Doe. The first query creates the user object. The second query creates a folder in the repository and the third one sets this new folder as the home folder for the new user.

CREATE dm_user OBJECT
SET user_name = 'Jane Doe',
SET user_login_name = 'jdoe',
SET user_address = '[e-mail]',
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 = 'jdoe',
SET owner_name = 'Jane Doe'
LINK '/Home'
usersDQL queriesUPDATE dm_user OBJECT
SET default_folder = '/Home/jdoe'
WHERE user_login_name...