Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

PPM command that can add user to a security group? Or must use GUI /or custom update script?

Highlighted
bzdafro
Collector

PPM command that can add user to a security group? Or must use GUI /or custom update script?

I believe the answer is no, but double checking.  Just wondering if there is a built in special command that allows you to add/or remove users from security groups.   Or does this need to be done via the workbench, or custom scripts?  

 

 

Thanks

1 REPLY
Jim Esler
Honored Contributor

Re: PPM command that can add user to a security group? Or must use GUI /or custom update script?

We usually add or drop users from security groups by entering entries in the knta_user_security_int and knta_users_int tables and running the Import Users report. This also adds or drops licenses as needed. In other cases we use a sql query to insert or delete an entry in the knta_user_security table. I am not aware of a special command that can do this. There may be a database procedure that provides this functionality but the sql query to do it directly is very simple.

//Add this to "OnDomLoad" event