3  Admin

Guides for admins managing the data catalog.

Giving User Permissions

Users have roles in each organization that give them different permissions.
The roles are:

  • Member: can see private datasets in the organization
  • Editor: can add private datasets to the organization and delete datasets from the organization
  • Admin: can change users’ roles in an organization and publish datasets from private to public

To give a user a role in an organization:

  1. Click on the Organizations tab at the top of the screen and click on the organization you want to add the user to.

  2. Click on the Manage button in the upper right.

  3. Click on the Members tab at the top.

    • To add a new member to the organizaton, click the Add Member button. Enter their username, select their new role from the dropdown, and click the Add Member button at the bottom of the form.

    • To change an existing member’s role, click the wrench next to their user name.

      • Select their new role from the dropdown menu and click Update Member
      • To remove the user from the organization completely, click the Delete button.

Reviewing and Publishing a Dataset

  1. Navigate to the dataset you would like to publish.
  2. Review the metadata and ensure the files/links are correct and function properly.
  3. To publish, click on the Manage button in the top right of the dataset page.
  4. In the metadata fields, find the Visibility field.
  5. Change the Visibility field from Private to Public, and click the Update Dataset button at the bottom of the form.

Deleting Datasets/Groups/Organizations

  1. To delete a dataset, group, or organization, navigate to it’s page and click the Manage button in the upper right.
  2. Click the Delete button at the bottom of the form to delete.
  3. Deleting a dataset, group, or organization does not remove it from the database. After deleting, a sysadmin can restore the item or purge it to remove it from the database. If not purged, the url for the deleted item cannot be reused.

Purge Deleted Datasets/Groups/Organizations

  1. Navigate to sysadmin settings by clicking the hammer icon at the top of the page.
  2. Click on the Trash tab. This page will list all the currently deleted datasets, groups, and organizations.
  3. You can purge all deleted items using the Purge all button at the top of the form. To purge only one group of items (datasets, group, or organizations) use the Purge button in that section.

Restore Deleted Datasets

  1. Navigate to sysadmin settings by clicking the hammer icon at the top of the page.
  2. Click on the Trash tab. This page will list all the currently deleted datasets, groups, and organizations.
  3. Click on the dataset you would like to restore, and click the Manage button in the upper right.
  4. In the metadata fields find the State field.
  5. Change the State field from Deleted to Active, and then click the Update Dataset button at the bottom of the form.

Restoring a Deleted User

When a user is deleted from the website, their information remains in the database with the state field set to deleted. To reactivate the user, you must set this field to active in the database.

  1. Enter the acep-db-cont docker container
    • docker exec -it acep-db-cont /bin/bash
  2. Access the postgres database
    • psql -U postgres
  3. List all the databases and connect to the ckandb database.
    • \l
    • \c ckandb
  4. List all the tables and list the columns of the user table.
    • \d
    • \d user
  5. List all the users in the user table.
    • SELECT * FROM public.user;
  6. Find the deleted user with the username [username].
    • SELECT id, name, email, state FROM public.user WHERE name = ‘[username]’;
  7. Update the user’s state field.
    • UPDATE public.user SET state = ‘active’ WHERE name = ‘[username]’;
  8. Find the user again and ensure that the state field is set to active.
    • SELECT id, name, email, state FROM public.user WHERE name = ‘[username]’;