NIH | National Cancer Institute | NCI Wiki  

Versions Compared

Old Version 15

changes.mady.by.user Unknown User (shestop1)

Saved on

compared with

New Version 16

changes.mady.by.user Unknown User (lustbaders)

Saved on

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=matyas' 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. This is optional if you do not wish to use coppatestgrid as your username.

    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,'/O=caBIG/OU=caGrid/OU=Training/OU=Dorian/CN=matyass','Steve','Matyas','','','','','','',null,null,now());
--user_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);

...