Monday, July 25, 2011

What are minimum permission request for Oracle user to install Quality Center

For Quality Center 9.2, 10.0:Refer to the Quality Center Installation guide for "User Permissions for Installing Quality Center on an Oracle Database" in the section Before You Install.
If you have the Oracle system user, you can use this user to install Quality Center. If you are unable to use the Oracle system user due to security reasons, it is recommended that your database administrator create a Quality Center database administrative user, for example qc_admin_db,with the specific privileges required to install Quality Center. Your database administrator can create a Quality Center database administrative user using the example script, qc_admin_db___oracle.sql, which is located in the \utilities\databases\scripts directory on the installation DVD. This script creates the Quality Center database administrative user with the recommended grants required on the database. Your database administrator should run the script and create this user on the staging database server.
The following are the recommended privileges required by the Quality Center database administrative user. Descriptions and additional explanations about these privileges can be found in the Quality Center 9.2 installation guide:
  • CREATE SESSION
  • CREATE USER
  • DROP USER
  • CREATE TABLE WITH ADMIN OPTION
  • CREATE VIEW WITH ADMIN OPTION
  • CREATE TRIGGER WITH ADMIN OPTION
  • CREATE SEQUENCE WITH ADMIN OPTION
  • CREATE PROCEDURE WITH ADMIN OPTION
  • CTXAPP Role WITH ADMIN OPTION
  • SELECT ON DBA_FREE_SPACE
  • SELECT ON SYS.DBA_TABLESPACES
  • SELECT ON SYS.DBA_USERS
  • SELECT ON SYS.DBA_REGISTRY
  • SELECT ON SYS.DBA_ROLES
  • SELECT ANY TABLE WITH ADMIN OPTION
  • INSERT ANY TABLE

No comments:

Post a Comment