root user

8 views
Skip to first unread message

Rich Ford

unread,
Dec 9, 2021, 11:16:02 AM12/9/21
to
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

Roy Hann

unread,
Dec 9, 2021, 11:59:45 AM12/9/21
to
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
Reply all
Reply to author
Forward
0 new messages