To add, edit and delete GUI users, you must have root access.

 

Access the script:

 

cd /home/tftpboot/bin

sh lbmp-DB_user_management.sh

 

 

Existing Users:                               List of roles

Role name | Superuser | Create role | Create DB | Connections | Member of

-----------+-----------+-------------+-----------+-------------+-----------

admin     | no        | no          | yes       | no limit    |

 

Add a User:

 

Select User Action:

Add new user, Change user password, Delete user

----> type response and press enter, "q" will quit the process

add, change, delete, quit; a/c/d/q: a

 

----> type response and press enter, "q" will quit the process

Enter a User name: jsmith

 

Avoid special characters, 4 characters required, more than 8 letters and numbers work best

Enter password for jsmith: ***********

 

Existing Users:                               List of roles

Role name | Superuser | Create role | Create DB | Connections | Member of

-----------+-----------+-------------+-----------+-------------+-----------

admin     | no        | no          | yes       | no limit    |

jsmith    | no        | no          | yes       | no limit    |

 

 

Select User Action:

Add new user, Change user password, Delete user

----> type response and press enter, "q" will quit the process

add, change, delete, quit; a/c/d/q: hdelatourhaute

 

Select User Action:

Add new user, Change user password, Delete user

----> type response and press enter, "q" will quit the process

? invalid action selection

add, change, delete, quit; a/c/d/q: a

 

----> type response and press enter, "q" will quit the process

Enter a User name: hdelatourhaute

 

Avoid special characters, 4 characters required, more than 8 letters and numbers work best

Enter password for hdelatourhaute: ******

 

Existing Users:                                 List of roles

  Role name    | Superuser | Create role | Create DB | Connections | Member of

----------------+-----------+-------------+-----------+-------------+-----------

admin          | no        | no          | yes       | no limit    |

hdelatourhaute | no        | no          | yes       | no limit    |

jsmith         | no        | no          | yes       | no limit    |

 

 

Change a password:

 

Select User Action:

Add new user, Change user password, Delete user

----> type response and press enter, "q" will quit the process

add, change, delete, quit; a/c/d/q: c

----> type response and press enter, "q" will quit the process

Change password of which user: jsmith

 

Avoid special characters, 4 characters required, more than 8 letters and numbers work best

Enter password for jsmith: ********

ALTERED ROLE

 

Existing Users:                                 List of roles

  Role name    | Superuser | Create role | Create DB | Connections | Member of

----------------+-----------+-------------+-----------+-------------+-----------

admin          | no        | no          | yes       | no limit    |

hdelatourhaute | no        | no          | yes       | no limit    |

jsmith         | no        | no          | yes       | no limit    |

 

 

Select User Action:

Add new user, Change user password, Delete user

----> type response and press enter, "q" will quit the process

add, change, delete, quit; a/c/d/q: q

#