bundle
and
ruby main.rb
-
create: Create User to specified database
-
rm: Removes User from specified database
-
add: Add Role to User: assigns one of the presetted roles to a user on a given database
-
list: Lists all Users and respective attributes or lists all Databases currently managed by PIUM
-
help: displays commands usage
-
exit: Quit PIUM
-
create <username> <password> <database> [options]
-
options list:
-
SUPERUSER | NOSUPERUSER |
-
CREATEDB | NOCREATEDB |
-
CREATEROLE | NOCREATEROLE |
-
INHERIT | NOINHERIT |
-
REPLICATION | NOREPLICATION
-
-
-
add <username> < ADMIN | READ_ONLY | READ_WRITE > <database>
-
ADMIN: User has total access to database, including the permission to create|drop tables;
-
READ_WRITE: User have total access to database values, but not the permission to create|drop tables;
-
READ_ONLY: User can only use SELECT command within the database;
-
-
rm <username> <database>
-
list < users | databases | groups >