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 = '[email protected]', 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...