Yes it is the is the classic error message 21776. Suggesting his name was not found in the users collection. Any idea what is causing this?

The user is a...

That'll do it.

Thanks!

You guys are awesome!!!!

I appreciate all your takes. Here's what was given to me for my recommendations:

Idea before DBA input:

Our environment includes 3 Web Servers(IIS) which are load balanced,...

I understand the need to change passwords for security purposes, but allowing end users to change their database passwords? This is the first I am hearing of this concept....

One question is why would you want users to change their passwords? As Noeld mentioned, you must grant users the correct level of permissions to run the aforementioned sprocs....

Thansk for all this great info.

I am sorry I neglected to provide some pertinent information about our server farm concept.

It appears that our topology would include Web servers, and application...

Hi,

I evaluate 3rd party software tools all the time. My theory is "Why re-invent the wheel?" But I do recommend the following:

*Always load demo software on test environments....

What about the standard role (user defined)? Here's my thought:

The developer instead of hard coding a generic userid (that multiple people would use)I create a role and assign users...

I am familiar with SQL Compare and SQL DataCompare. Do you know of anything free by any chance? Too much red tape here, would take a month just...

Thanks guys, all of this makes perfect sense. Now let me organize it into a brief to the point Pro's and Con's.

Thanks again for the feedback, it was very...

As usual Phill, you are the man!!!

This was very handy!

Aurora01

I found out the problem I will share for anyone else who may come across this.

In the data pump task, on the transformations tab there is an option to...

Oops, sorry about the cofusion. I get the values from the SQL dB, and based off of those 'output params', I run a select (data pump task) to get...

Thanks Phill, that just may work. This is definitely a development environment.

Steven, you are right. It would be most helpful to read the Oracle log, (Q-log)but wouldn't we need an app to do that?