1. Forum
  2. USENET
  3. comp.databases.ingres

  • root user

    From Rich Ford@richford990@gmail.com to comp.databases.ingres on Thu Dec 9 08:16:01 2021
    From Newsgroup: comp.databases.ingres

    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
    --- Synchronet 3.21b-Linux NewsLink 1.2
  • From Roy Hann@specially@processed.almost.meat to comp.databases.ingres on Thu Dec 9 16:59:43 2021
    From Newsgroup: comp.databases.ingres

    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
    --- Synchronet 3.21b-Linux NewsLink 1.2