[Info-ingres] root user

[Roy Hann]

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