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
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 = 'firstname.lastname@example.org', SET user_group_name = 'docu', SET user_source = 'inline ...