RetroBBS - comp.databases.ingres

root user

<d3276706-1849-4d28-8bcc-cad5f3c3639dn@googlegroups.com>

https://www.rocksolidbbs.com/devel/article-flat.php?id=168&group=comp.databases.ingres#168

copy link Newsgroups: comp.databases.ingres

X-Received: by 2002:ac8:4a0e:: with SMTP id x14mr18631214qtq.345.1639066562185;
Thu, 09 Dec 2021 08:16:02 -0800 (PST)
X-Received: by 2002:a05:6808:150d:: with SMTP id u13mr6525440oiw.155.1639066561799;
Thu, 09 Dec 2021 08:16:01 -0800 (PST)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!news.misty.com!border2.nntp.dca1.giganews.com!border1.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.databases.ingres
Date: Thu, 9 Dec 2021 08:16:01 -0800 (PST)
Injection-Info: google-groups.googlegroups.com; posting-host=2600:8801:d500:6b60:5daf:70f5:86e:5b06;
posting-account=MD_47woAAABULmOe11ZqdjPGw6zni88O
NNTP-Posting-Host: 2600:8801:d500:6b60:5daf:70f5:86e:5b06
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <d3276706-1849-4d28-8bcc-cad5f3c3639dn@googlegroups.com>
Subject: root user
From: richford990@gmail.com (Rich Ford)
Injection-Date: Thu, 09 Dec 2021 16:16:02 +0000
Content-Type: text/plain; charset="UTF-8"
Lines: 7

by: Rich Ford - Thu, 9 Dec 2021 16:16 UTC

What is the purpose of the root user in the Ingres database?

CREATE USER root WITH
NOPROFILE,
PRIVILEGES=(CREATEDB,CHANGE_PASSWORD,TRACE,SECURITY,MAINTAIN_LOCATIONS,OPERATOR,AUDITOR,MAINTAIN_AUDIT,MAINTAIN_USERS);

Thanks,
Rich

Re: root user

<sotclv$1om1$1@gioia.aioe.org>

copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=169&group=comp.databases.ingres#169

copy link Newsgroups: comp.databases.ingres

Path: i2pn2.org!i2pn.org!aioe.org!ow2HZ3WUoSa7bUAoHqrJ8A.user.46.165.242.75.POSTED!not-for-mail
From: specially@processed.almost.meat (Roy Hann)
Newsgroups: comp.databases.ingres
Subject: Re: root user
Date: Thu, 9 Dec 2021 16:59:43 -0000 (UTC)
Organization: Aioe.org NNTP Server
Message-ID: <sotclv$1om1$1@gioia.aioe.org>
References: <d3276706-1849-4d28-8bcc-cad5f3c3639dn@googlegroups.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Injection-Info: gioia.aioe.org; logging-data="58049"; posting-host="ow2HZ3WUoSa7bUAoHqrJ8A.user.gioia.aioe.org"; mail-complaints-to="abuse@aioe.org";
User-Agent: XPN/1.2.6 (Street Spirit ; Windows)
X-Notice: Filtered by postfilter v. 0.9.2

by: Roy Hann - Thu, 9 Dec 2021 16:59 UTC

Rich Ford wrote:

> What is the purpose of the root user in the Ingres database?
>
> CREATE USER root WITH
> NOPROFILE,
> PRIVILEGES=(CREATEDB,CHANGE_PASSWORD,TRACE,SECURITY,MAINTAIN_LOCATIONS,
> OPERATOR,AUDITOR,MAINTAIN_AUDIT,MAINTAIN_USERS);

I can't think of a good reason.

Perhaps someone thought it was a way to give an already privileged user
(other than the Ingres installation owner) privileged access to Ingres
too.

Personally I like to have a user called "ingres" to own the installation
and be in control of its processes and resources, and then I create
user IDs to own databases and hence to be the DBA of those databases,
with DBA privileges in them. I think that is the best way to
compartmentalize privilege in an Ingres environment.

Roy

"Here comes Mr. Bill's dog." -- Narrator, Saturday Night Live

devel / comp.databases.ingres / root user

Subject	Author
root user	Rich Ford
Re: root user	Roy Hann