CODEWITHSUNDEEP
dqldocumentum
eivamu
eivamu

Reputation: 3225

Documentum DQL: Change user type

Is it possible to change the object type of users?

CHANGE dm_user OBJECT TO my_user WHERE r_object_id = '{some id}'

Given that my_user is a subtype of dm_user, the query above results in the following error message:

[DM_QUERY_E_CHANGE_NON_SYSOBJECT]error:  "The CHANGE OBJECT statement can only be used on dm_sysobject or its subtypes."

So even though it is seemingly impossible, is there a way to hack this?

Upvotes: 2

Views: 2144

Answers (1)

Miki
Miki

Reputation: 2517

There is a way, I tested it and it works. You need to create new user object of type you previously created it, for example:

CREATE custom_user OBJECT SET user_name = 'Test user' SET user_os_name = 'test_user' 
    SET user_address = '[email protected]' 
    SET default_folder = '/Temp' 
    SET description = 'Test' 
    SET user_login_name = 'test_user'

After it I made final setup of user object through Documentum Administrator (DA): setting inline password, user privilege etc. I validated user by logging in via DA. Everything works great!

I have configured reassign details for some other user object in repository and ran Reassign Job. All user details of configured users have been successfully transfered to my test user object like it should be with this standard OOTB procedure of the reassigning users.

Upvotes: 1

Related Questions