If you exported and then reimported any Oracle-based object
stores, it is a best practice to revoke any increased privileges or
roles that you granted to the corresponding tablespace owners.
To determine whether you need to revoke privileges or roles
on the Oracle object store tablespaces:
- At a command prompt run the command sqlplus username and
specify the password when prompted. username is
the owner of the tablespace corresponding to the object store.
- To determine whether privileges and roles need to be revoked,
run the following SQL command at the prompt:
SELECT
* FROM all_sequences WHERE sequence_name = 'CONTENTQUEUESEQUENCE';
- If the command returns sequences from users other than
the tablespace owner, revoke the DBA privilege and the EXP_FULL_DATABASE
and IMP_FULL_DATABASE roles from the tablespace owner:
revoke dba from username;
revoke EXP_FULL_DATABASE from username;
revoke IMP_FULL_DATABASE from username;
- Repeat this procedure for each object store that you upgraded.