Highlighted
Absent Member.
Absent Member.
72 views

UCMDB Support Tip: Oracle DB excesive rights

Hi all,

 

Yes, you have read the title well. It can happend to have excesive rights given to the uCMDB user trying to write to the database and this can cause issues. In order to avoid this please follow the database manual recommandation. The following database permissions must be granted to HP Universal CMDB Oracle schema users. These permissions are also used by the HP Universal CMDB installer to create a new Oracle user:

 

Roles

  Connect

Privileges

CREATE TABLE

CREATE VIEW

CREATE SEQUENCE

CREATE TRIGGER

CREATE PROCEDURE

UNLIMITED TABLESPACE

ALTER USER ${user} DEFAULT ROLE ALL

CREATE TYPE TO

 

Best regards,

Andrei Matei

Best regards,
Andrei Matei
uCMDB Support Engineer

“HP Support
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.”
Labels (1)
Tags (1)
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.