Revoking Unnecessary Grants

For security purposes, you must revoke all unnecessary grants on the schema. This refers to grants that are needed during installation and are not required during runtime. You must have database administrator privileges to perform this action.

1. Revoke unnecessary grants from Omics Data Bank Schema.

   Execute odb_revoke_grants.sql to remove unnecessary grants from the Omics Data Model Schema. This script should be executed by a user with database administrator privileges.

2. Revoke unnecessary grants from Cohort Data Model Schema.

   Execute cohort_revoke_grants.sql to remove unnecessary grants from Cohort Data Model Schema. This script should be executed by a user with database administrator privileges.