NIH | National Cancer Institute | NCI Wiki  

Versions Compared

Old Version 12

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

Saved on

compared with

New Version 13

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

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

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

    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);
    Reset your local dev instances

Adding your own Grid Identity to PO

Steps TBD.