Re: changing the owner of database objects

From: Sridhar Subramaniam <avion_at_ozemail.com.au>
Date: 1995/11/11
Message-ID: <30A59241.5DB2_at_ozemail.com.au>#1/1

Roland Schaetzle wrote:
>
> Hallo,
>
> how can I change the ownership of all database objects belonging
> to a certain user?
>
> Roland
>
>

---

> Roland Schaetzle email:
 schaetzle_at_aifb.uni-karlsruhe.de
> Institut AIFB Tel. : +49-721-608-4061
> Universitaet Karlsruhe
> ---------- D-76128 Karlsruhe -- Englerstr.11 -- Raum 229

---

Roland,
1. Export all objects belonging to the user and import them using the 'fromuser/touser' option.
2. Update sys.obj$ - this sure is not recommended.

-- 
Cheers

Sridhar Subramaniam
Avion Consulting Services
Sydney - Australia
Email : ssubrama_at_nibucorp.ccdn.otc.com.au / avion_at_ozemail.com.au

Disclaimer : All opinions are truly and just mine.

Received on Sat Nov 11 1995 - 00:00:00 CET