Issue with the DB permissions provided during the OMi DB configuration
I installed OMi 10.01 in my environment with Oracle 11g as my database.
One of the requirement in the OMI Database guide specifically mentions the below line:
GRANT UNLIMITED TABLESPACE TO <HP Operations Manager i Oracle user schema>
However, when the installation is completed, the DBA raised the concern that the unlimited tablespace permission was granted to the whole database instead of restricting to only my datababases (MGMT, Event, RTSM).
1.Can I get the permission revoked and have only unlimited tablespace only to my 3 databases and can still the application work properly?
2. Why is unlimited tablespace granted to the whole database.
The DBA created the tablespace and I created the 3 schemas during my OMi installation and I've used 'system' account to perform the DB configuration.
Regarding your question and I do some researches and revert back to you if found useful information.
Minh Nguyen | SW Technical Support Engineer.
Operations Manager i and Operations Manager
Hewlett-Packard (SSO Portal)
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.