O'Reilly logo

Documentum 6.5 Content Management Foundations by Pawan Kumar

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 = 'jdoe@doquent.com', SET user_group_name = 'docu', SET user_source = 'inline ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required