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?
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.
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.
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.