Re: Renaming Owner of the DB

Posted in 2004

Andy Kent — 6 Jan 2004 05:25:56 -0800 — source: Usenet: comp.databases.informix

A database very definitely *does* have an owner - just take a look in onmonitor | Status | Databases. I don't believe the owner can be changed, but that doesn't seem to be the motive behind the question - removing the relevant privileges will do the trick, as Jonathan explains. Ownership and privileges are not the same thing. Andy "Murray Wood \$IList\$" <ifxmaillist@quanta.co.nz> wrote in message news:<bta16t$os5$1@terabinaries.xmission.com>... > 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

↪ replying to Andy Kent

Colin Dawson — Tue, 6 Jan 2004 20:12:30 +0000 — source: Usenet: comp.databases.informix

But doesn't the creator of an object have absolute rights over it so there would be no specific privileges to remove. If I produced a schema There is not an SQL statement granting DBA to that user - because that user created the DB so has full privileges over it and anything created within. Colin In message <a3525a11.0401060525.3bc5067f@posting.google.com>, Andy Kent <andykent.bristol@virgin.net> writes >A database very definitely *does* have an owner - just take a look in >onmonitor | Status | Databases. > >I don't believe the owner can be changed, but that doesn't seem to be >the motive behind the question - removing the relevant privileges will >do the trick, as Jonathan explains. Ownership and privileges are not >the same thing. > >Andy > > > >"Murray Wood \$IList\$" <ifxmaillist@quanta.co.nz> wrote in message >news:<bta16t$os5$1@terabinaries.xmission.com>... >> 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 --

↪ replying to Colin Dawson

Colin Dawson — Tue, 6 Jan 2004 20:37:00 +0000 — source: Usenet: comp.databases.informix

Sorry about the confusion, running DBSCHEMA does include an SQL statement granting DBA privileges to the user. If I revoke this user's privileges to 'connect' would I still have to modify the owner to remove table level privileges? Colin In message <5SDCNvAuax+$Ewi$@fdsltd.plus.com>, Colin Dawson <Colin@colindawson.com> writes >But doesn't the creator of an object have absolute rights over it so >there would be no specific privileges to remove. > >If I produced a schema There is not an SQL statement granting DBA to >that user - because that user created the DB so has full privileges >over it and anything created within. > > >Colin > > > >In message <a3525a11.0401060525.3bc5067f@posting.google.com>, Andy Kent ><andykent.bristol@virgin.net> writes >>A database very definitely *does* have an owner - just take a look in >>onmonitor | Status | Databases. >> >>I don't believe the owner can be changed, but that doesn't seem to be >>the motive behind the question - removing the relevant privileges will >>do the trick, as Jonathan explains. Ownership and privileges are not >>the same thing. >> >>Andy >> >> >> >>"Murray Wood \$IList\$" <ifxmaillist@quanta.co.nz> wrote in message >>news:<bta16t$os5$1@terabinaries.xmission.com>... >>> 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 > --

↪ replying to Colin Dawson

Andy Kent — 7 Jan 2004 03:26:17 -0800 — source: Usenet: comp.databases.informix

Just make sure you create the individual tables with a suitable owner name. Andy Colin Dawson <Colin@colindawson.com> wrote in message news:<4yTCFHCsxx+$EwAM@fdsltd.plus.com>... > Sorry about the confusion, running DBSCHEMA does include an SQL > statement granting DBA privileges to the user. > > If I revoke this user's privileges to 'connect' would I still have to > modify the owner to remove table level privileges? > > > Colin > > > In message <5SDCNvAuax+$Ewi$@fdsltd.plus.com>, Colin Dawson > <Colin@colindawson.com> writes > >But doesn't the creator of an object have absolute rights over it so > >there would be no specific privileges to remove. > > > >If I produced a schema There is not an SQL statement granting DBA to > >that user - because that user created the DB so has full privileges > >over it and anything created within. > > > > > >Colin > > > > > > > >In message <a3525a11.0401060525.3bc5067f@posting.google.com>, Andy Kent > ><andykent.bristol@virgin.net> writes > >>A database very definitely *does* have an owner - just take a look in > >>onmonitor | Status | Databases. > >> > >>I don't believe the owner can be changed, but that doesn't seem to be > >>the motive behind the question - removing the relevant privileges will > >>do the trick, as Jonathan explains. Ownership and privileges are not > >>the same thing. > >> > >>Andy > >> > >> > >> > >>"Murray Wood \$IList\$" <ifxmaillist@quanta.co.nz> wrote in message > >>news:<bta16t$os5$1@terabinaries.xmission.com>... > >>> 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 > > > > --

↪ replying to Andy Kent

Ferronato — 7 Jan 2004 08:01:27 -0800 — source: Usenet: comp.databases.informix

Hi all , You can be sure that databases (and all other objects) does have an Owner: execute this statement in dbaccess, e. g. Select * from sysmaster:sysdatabases ; Then, you can see the owner of each database!! IF YOU DON'T want to allow users create databases, ONLY informix, you should add a line in "onconfig" file: # Only informix user can create database DBCREATE_PERMISSION informix If you want allo informix and root users to create databases: # Only informix user can create database DBCREATE_PERMISSION informix,root Best regards !!! Good luck !! RFO andykent.bristol@virgin.net (Andy Kent) wrote in message news:<a3525a11.0401070326.7bef8fd9@posting.google.com>... > Just make sure you create the individual tables with a suitable owner name. > > Andy > > Colin Dawson <Colin@colindawson.com> wrote in message news:<4yTCFHCsxx+$EwAM@fdsltd.plus.com>... > > Sorry about the confusion, running DBSCHEMA does include an SQL > > statement granting DBA privileges to the user. > > > > If I revoke this user's privileges to 'connect' would I still have to > > modify the owner to remove table level privileges? > > > > > > Colin > > > > > > In message <5SDCNvAuax+$Ewi$@fdsltd.plus.com>, Colin Dawson > > <Colin@colindawson.com> writes > > >But doesn't the creator of an object have absolute rights over it so > > >there would be no specific privileges to remove. > > > > > >If I produced a schema There is not an SQL statement granting DBA to > > >that user - because that user created the DB so has full privileges > > >over it and anything created within. > > > > > > > > >Colin > > > > > > > > > > > >In message <a3525a11.0401060525.3bc5067f@posting.google.com>, Andy Kent > > ><andykent.bristol@virgin.net> writes > > >>A database very definitely *does* have an owner - just take a look in > > >>onmonitor | Status | Databases. > > >> > > >>I don't believe the owner can be changed, but that doesn't seem to be > > >>the motive behind the question - removing the relevant privileges will > > >>do the trick, as Jonathan explains. Ownership and privileges are not > > >>the same thing. > > >> > > >>Andy > > >> > > >> > > >> > > >>"Murray Wood \$IList\$" <ifxmaillist@quanta.co.nz> wrote in message > > >>news:<bta16t$os5$1@terabinaries.xmission.com>... > > >>> 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 > > > > > > > --