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
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)