Re: Change objects ownership ? Can I do it ?

Carlos Palma wrote:
>
> I have this little problem:
>
> I've created all my database objects logged as a certain user.
> How can I change the owner of these objects, besides the export/import
> solution ?
>
> Any reply will be greatly appreciated,
> Carlos
>
> Carlos Alberto Palma
> SMD Informatica, S.A.
> Tel.: +351.1.472 92 00 Home : 959 21 05
> Fax : +351.1.472 92 92 E-Mail : cap_at_smd.pt

Carlos,
Though i wouldn't recommend, but you can get away with this :

update sys.obj$
set owner#=<user_id of the new user>
where name = <table_name>
and owner = <user_id of old user>;

-- 
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.