Re: Renaming Owner of the DB
Discussion of whether an Informix database has an owner. Andy Kent said it does and that removing privileges, not renaming, is the answer; Colin Dawson noted dbschema shows a DBA grant to the creator. Andy advised creating tables with a suitable owner name. Ferronato said sysmaster:sysdatabases shows owners and DBCREATE_PERMISSION in onconfig restricts who can create databases.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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
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 --
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 > --
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 > > > > --
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
> > >
> >
> > --