Is there any way to change the owner of a database once
the database has been created? I don't want to have to unload
and reload the DB. Could I modify some ii tables?
Unfortunatly this isnt as easy as you may think! Not only would you have
to play with object ownership on the database, you'd have to monkey with
iidatabase in iidbdb, but worst of all you'd have to play with the config
files for the database. The latter would require a binary editor or C
Unloading and reloading may be slow, but at least it is fully supported by
CA. Furthermore, the DBA Guide describes the process fully for you.
> Is there any way to change the owner of a database once
> the database has been created? I don't want to have to unload
> and reload the DB. Could I modify some ii tables?
> Somckit Khemmanivanh
I know it is possible to change the database owner, but am I able to
the owner of a table as well? Currently, the owner of the database and
is EXAV. The problem is for the programmers... this is the only table
anyone other than DBO. We've got some code that is supposed to work
for both tables and it causes them some coding problems because that
isn't the same. For the tables owned by EXAV, they have to code it
and for the tables owned by DBO, they just code the tablename.
Is there anything I can do short of creating a new database and copying
the data over?
Thanks for the advice!
10. change Db owner