Start of changeFileNet P8 Content Engine, FileNet P8 Content Search Engine, Version 5.0.+   Database:  Oracle          

Revoking increased privileges and roles on Oracle object store tablespaces

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:
  1. 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.
  2. 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';

  3. 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;
  4. Repeat this procedure for each object store that you upgraded.


Feedback

Last updated: November 2010


© Copyright IBM Corporation 2010.
This information center is powered by Eclipse technology. (http://www.eclipse.org)
End of change