Super Contributor.. JamesLindsay Super Contributor..
Super Contributor..
120 views

HPOO 10.60 DB Account Permissions

We are about to go into our production environment with HPOO 10.60. Doing so means that our HPOO Db account to the HPOO Db will have its DDL permissions (ALTER,CREATE,DISABLE/Enable TRIGGER,DROP,TRUNCATE,UPDATE STATISTICS) .removed. Is this going to affect the operation of HPOO 10.60 in a negative way?

Labels (1)
0 Likes
2 Replies
Josue_G_OO Respected Contributor.
Respected Contributor.

Re: HPOO 10.60 DB Account Permissions

OO will work fine since I guess is already installed and objects, tables were created etc - perhaps when doing an upgrade you might encounter issues since it is highly recommended to grant OODBUSER DDL privileges in order to allow OO to perform upgrade operatations without manual intervention as these operations require modification on the DB structure. Anyway you can create the database objects manually by running the script mentioned on the OO database guide in case of lacking permission due to security restrictions.

Josue Gómez
Customer Support Engineer

If you find that this or any other post resolves your issue, please be sure to mark it as an accepted solution.
If you are satisfied with anyone’s response please remember to give them a KUDOS by clicking on the STAR at the bottom left of the post and show your appreciation.
0 Likes
Super Contributor.. JamesLindsay Super Contributor..
Super Contributor..

Re: HPOO 10.60 DB Account Permissions

Since doing it the only limiation I find is when deleteing content packs.

[taskExecutor-1] (DeploymentProcessServiceImpl.java:376) ERROR - Exception During Deployment:

org.springframework.dao.TransientDataAccessResourceException: StatementCallback; SQL [truncate table OO_CACHED_GRAPHS]; Cannot find the object "OO_CACHED_GRAPHS" because it does not exist or you do not have permissions.; nested exception is java.sql.SQLException: Cannot find the object "OO_CACHED_GRAPHS" because it does not exist or you do not have permissions.

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.