Re: Changing ownership...

Posted in 2000

Carlos Benjamin — Fri, 29 Sep 2000 15:23:21 -0700 (PDT) — source: Informix-list mailing list archive (1991-1998)

--- "Prasad Mahale" <gs0528@hotmail.com> > wrote: >Hi All, >I want to change ownership of some of the tables in my database. The way i >know is by recreating the table with new ownership info. This does'nt look >easy considering my database size. >Is there any easiest way, any tricks (any script?) to do this? > >Thanks in advance > >-Prasad While you can grant and revoke privileges, there is no way to dynamically change ownership according to the Informix Guide to SQL manual. Nor could I find a way to grant/revoke table level privileges on the entire database. Two things I was trying to find workarounds for the other day. I'd cruise the IIUG repository for any tools that might do the deed. == Maintainer of the procrastinator's FAQ. Well, maybe tomorrow I will be. _____________________________________________________________ Want a new web-based email account ? ---> http://www.firstlinux.net