[ 
https://issues.apache.org/jira/browse/AIRAVATA-2232?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15702968#comment-15702968
 ] 

Marcus Christie commented on AIRAVATA-2232:
-------------------------------------------

Script for adding column to table:
{code:sql}
alter table credential_store.credentials add column CREDENTIAL_OWNER_TYPE 
VARCHAR(10) DEFAULT 'GATEWAY' NOT NULL;
{code}

Still need to come up with script for populating this column for existing 
credentials.

> All SSH keys generated by a gateway admin are listed in user's settings --> 
> credential store
> --------------------------------------------------------------------------------------------
>
>                 Key: AIRAVATA-2232
>                 URL: https://issues.apache.org/jira/browse/AIRAVATA-2232
>             Project: Airavata
>          Issue Type: Bug
>          Components: Airavata System, PGA PHP Web Gateway
>         Environment: dev.seagrid.org
>            Reporter: Eroma
>            Assignee: Marcus Christie
>
> Gateway admins generates SSH keys for the gateway, to be used in community 
> account usage. Also admins will generate SSH keys to be used with their own 
> user settings for compute resources.
> All these keys are listed under users own credential store. Users own 
> crendetial store should only have keys generated for own resource logins. 
> This is through User settings in PGA.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to