RE: Renaming Owner of the DB

Tables, indexes, constraints, procedures have an owner. The database does not have an owner. It does not matter who is the owner and you can not change this (without export/import). MW > -----Original Message----- > From: owner-informix-list@iiug.org > [mailto:owner-informix-list@iiug.org]On Behalf Of Colin Dawson > Sent: Sunday, 4 January 2004 7:00 p.m. > To: informix-list@iiug.org > Subject: Renaming Owner of the DB > > > This may sound like a stupid question but.... > > Can I change the owner of a database? Export/Import is not an option. > Reason being, I want to remove the privileges of being the creator of > the DB from that user. > -- > sending to informix-list

Murray Wood (IList) wrote: > Tables, indexes, constraints, procedures have an owner. The database does > not have an owner. It does not matter who is the owner and you can not > change this (without export/import). >Colin Dawson asked: >>Can I change the owner of a database? Export/Import is not an option. >>Reason being, I want to remove the privileges of being the creator of >>the DB from that user. Actually, the database does have an owner. And the owner is the default DBA. So, to remove the privileges of the database creator, you need to have one of the DBA's revoke all privileges from the cretor. Note that it takes a number (3) of REVOKE statements to do this - removing DBA privileges leaves a user with RESOURCE privileges, and removing RESOURCE privileges leaves a user with CONNECT privileges. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/