• Re: root user

    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
    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)
  • From Rich Ford@21:1/5 to All on Thu Dec 9 08:16:01 2021
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)