Page History
...
- Add your Grid Identity to your local PO database. Example shows adding '/O=caBIG/OU=caGrid/OU=Training/OU=Dorian/CN=matyascoppagridtest' Grid Identity.
Note This step is optional; you can use the coppatestgrid user without adding your grid identity to the DB.
Replace "coppagridtest" with your own account as needed.Note If anyone can improve the SQL to simply insertion, please do.
Code Block sql sql INSERT INTO CSM_USER (LOGIN_NAME, FIRST_NAME, LAST_NAME, PASSWORD) VALUES ('
Code Block --adding /O=caBIG/OU=caGrid/OU=Training/OU=Dorian/CN=<YOURUSERNAME> as a grid client test user account --NOTE: depending on the existing user keys you may need to adjust the user_id value INSERT INTO csm_user (user_id, login_name, first_name, last_name, organization, department, title, phone_number, password, email_id, start_date, end_date, update_date) values (8,coppagridtest','Test','GridClientUser',''); INSERT INTO CSM_USER_GROUP (USER_ID, GROUP_ID) VALUES ((select user_id from csm_user where login_name = '/O=caBIG/OU=caGrid/OU=Training/OU=Dorian/CN=matyasscoppagridtest','Steve','Matyas','','','','','','',null,null,now()); --user_), (select group_id must be unique, user_id must correspond to value inserted above INSERT INTO csm_user_group (user_group_id, user_id, group_id) Values (8, 8, 5);
Adding your own Grid Identity to PO
...
from csm_group where group_name = 'gridClient'));