Change schema owner
I've been asked to change schema owners for a development instance of Agile.
Now, I'm not a DBA, nor an application guy: I'm just a unix SA, and not very damned bright at that. So I don't know much about databases or the Agile application.
This is what I'm told has been done.
The agile app guys say the application is not looking at the 'new' data but the old. DBA team concurs that it is using the OLD schema, it should be using the NEW.
Now, I'm not a DBA, nor an application guy: I'm just a unix SA, and not very damned bright at that. So I don't know much about databases or the Agile application.
This is what I'm told has been done.
- Database has been backed up.
- Schema has been recreated using new owner
- Database imported.
The agile app guys say the application is not looking at the 'new' data but the old. DBA team concurs that it is using the OLD schema, it should be using the NEW.
0