Subject Re: [ib-support] DDL
Author Milan Babuskov
louis wrote:
> Is there another way to move ownership of all the structures to user
> "XXX"?


> If we backup the existing database (as SYSDBA) and restore it as "XXX"
> would this achieve our objective?

AFAIK, It should.

> I am asking this as the user site is remote and we have no active
> connection and we don't have the luxury of trial and error.

You can make test db with 2 tables on your machine and test it in few
minutes, no?