NIH | National Cancer Institute | NCI Wiki  

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. 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.

    Note

    If anyone can improve the SQL to simply insertion, please do.

    Replace "coppagridtest" with your own account as needed.
    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

...

  1. from csm_group where group_name = 'gridClient'));