10 Replies Latest reply on Apr 14, 2014 3:37 AM by andrewmy

Third Party Applications stops functioning

2645706 Apr 2, 2014 9:51 AM

Oracle database 11gR2 is deployed on Solaris and Linux Platform.After enabling Database vault features in oracle 11 G R2.

When we attempted to enabled db vault on oracle database we observed that my application stop functioning.

My query is what is methodology to enable DB vault in production environment so it doesn't impact my production application after deploying DB vault feature..

1. Re: Third Party Applications stops functioning

JustinCave Apr 2, 2014 5:41 PM (in response to 2645706)

Define "stop functioning". Are you getting errors? If so, what errors?

Justin
Like Show 1 Likes(1)

Actions
2. Re: Third Party Applications stops functioning

Emad Al-Mousa Apr 3, 2014 4:31 AM (in response to 2645706)

some third party applications are not "certified" to be functioning with Oracle Database Vault. Refer to the "vendor" of your application wither it will work or not.

also, as justin mentioned, what errors are you recieving.

Regards,
Emad
Like Show 1 Likes(1)

Actions
3. Re: Third Party Applications stops functioning

2645706 Apr 4, 2014 6:12 PM (in response to 2645706)

Thanks for your response..

1)
Application Error
Code:ORA-00942
Text:table or View doesnt exist

2) Owner must have system privilges " Alter User" to execute this method...
Like Show 0 Likes(0)

Actions
4. Re: Third Party Applications stops functioning

2645706 Apr 4, 2014 6:15 PM (in response to JustinCave)

Thanks for your response..

1)
Application Error
Code:ORA-00942
Text:table or View doesnt exist

2) Owner must have system privilges " Alter User" to execute this method...

Please advice me for same..

Before Enabling DB Vault can we verfiy what are the Privliges rights given to any User..

Best Regards
Like Show 0 Likes(0)

Actions
5. Re: Third Party Applications stops functioning

Emad Al-Mousa Apr 4, 2014 9:17 PM (in response to 2645706)

check this: http://docs.oracle.com/cd/B28359_01/server.111/b31222/cfgfact.htm#DVADM70241

Using Database Vault Secure Application Roles to restrict the data access from designated application | Oracle-Hands-On

it seems an authorization access issue.

Regards,
Like Show 1 Likes(1)

Actions
6. Re: Third Party Applications stops functioning

2645706 Apr 6, 2014 7:58 AM (in response to 2645706)

Hi Al-Mousa,
Thanks for your help..

Gone through the first link which you have provided but confused, Its mentioned What to expect After you install Oracle DB Vault..

When you install Oracle Database Vault, the installation process modifies several database initialization parameter settings to better secure your database configuration

Privileges that are revoked from Existing Users and Roles
Privilges that are prevented for Existing Users and Roles.
........................................................................................................................................................................
I have not worked on DB Vault my concepts are not cleared ,

So how to analyzewhat are the privileges revoke before enabling Oracle DB Vault so similar we can Grant it.

or

We have Grant the privliges for specific database Owner..

or

We have to give Roles and Authorization in DB Vault confguration.

Please advice.

Jazak Allah ul kair
Like Show 0 Likes(0)

Actions
7. Re: Third Party Applications stops functioning

Emad Al-Mousa Apr 7, 2014 3:47 AM (in response to 2645706)

Hi 2645706,

i would really like to help you more, but i think you need support on site to review your database vault setup and check directly your database.

Regards,
Like Show 1 Likes(1)

Actions
8. Re: Third Party Applications stops functioning

2645706 Apr 7, 2014 9:03 AM (in response to Emad Al-Mousa)

Thanks..
Like Show 0 Likes(0)

Actions
9. Re: Third Party Applications stops functioning

2645706 Apr 10, 2014 9:05 PM (in response to 2645706)

Before Enabling Oracle Database Vault, the database is working smooth without any error.

But Oracle DB Vault & features we are facing issues with multiple errors..

1.ORA-01031
Text Insufficient Privileges

ORA-06512 at line 1

2. Owner must have system sufficient Privilges "ALTER USER " to execute this method.

We are running Oracle Database 11gr2 with Oracle DB Vault compoenent.

Remarks: If i grant DV_ACC to USER1, everything works for him without any error.

Please do the needful
Like Show 0 Likes(0)

Actions
10. Re: Third Party Applications stops functioning

andrewmy Apr 14, 2014 3:37 AM (in response to 2645706)

There is no way to know what privileges are required by your 3rd party application to work. The only person who would know would be the vendor who supports the application. You need to contact them and request an answer to whether their software is database vault compatible. Why did you not check this with them BEFORE you installed Database Vault? You no longer have a support contract?

But having said that, from my experience of dealing with many apps written by 3rd party vendors (even large ones), they don't have a clue themselves and used the lazy method of granting powerful privileges/roles ALL, DBA, etc. to be granted to the users in order to work.

If you cannot contact your vendor and you need Database Vault then you are in for a long, rocky road of trying to map out all the privileges required by the application by trial and error - resolving privilege errors one by one until you get them all documented. Depending on how complicated the application is and how tightly you want to secure your database to be this could take anywhere from a few hours to hundreds of hours.
Like Show 1 Likes(1)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.