Multiple roles to a user

GreatKarur

Hi,

We are adding/removing the roles for a user using DA. It is taking lots of time while adding/removing multiple roles to a user manually using DA.

Is there any DFC/DQL to add/remove multiple user ?

Any help is much appreciated.

Regards,

Rajkumar Sukumar

dm_user

Here is few Queries for adding users and groups into another group

The following query creates a group named zone1_all and adds two groups as its members:

CREATE PUBLIC GROUP 'zone1_all' MEMBERS 'zone1_loanofficer', 'zone1_processor'

The following query adds two members to an existing group:

ALTER GROUP 'zone1_loanofficer' ADD 'Sam','John'

Group members can be removed by using DROP instead of ADD in the preceding query.

The members in the CREATE GROUP and ALTER GROUP queries can also be specified via a SELECT query. For example:

ALTER GROUP 'zone1_loanofficer' ADD (SELECT user_name from dm_user WHERE description = 'Loan Officer')