...
Code Block | ||||
---|---|---|---|---|
| ||||
CREATE ROLE DATICAL_PACKAGER_ROLE NOT IDENTIFIED; -- When using the tracefileLocation=REMOTE, you will need to setup the following permissions. -- Note: These permissions are only required on schemas running the Convert SQL Scripts command. This is only needed on the packaging / reference database. GRANT CREATE ANY DIRECTORY TO DATICAL_PACKAGER_ROLE; GRANT DROP ANY DIRECTORY TO DATICAL_PACKAGER_ROLE; -- The following permissions are needed for backing up and restoring the database. This is only needed on the packaging / reference database. GRANT EXP_FULL_DATABASE TO DATICAL_PACKAGER_ROLE; GRANT IMP_FULL_DATABASE TO DATICAL_PACKAGER_ROLE; -- The following permission is required if you you have Data Vault installed. This is only needed on the packaging / reference database. GRANT BECOME USER TO DATICAL_PACKAGER_ROLE; -- The following permission is required only if you use security policies. This is only needed on the packaging / reference database. GRANT EXEMPT ACCESS POLICY TO DATICAL_PACKAGER_ROLE; |
...