From Roy Hann@21:1/5 to Rich Ford on Thu Dec 9 16:59:43 2021
Rich Ford wrote:
What is the purpose of the root user in the Ingres database?
CREATE USER root WITH
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
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.