Customer and user management

Unibase stores user and customer management basic data in /usr/local/app (later to be changed to /usr/local/ub/etc).

The two tables (defined in the local dict.dat) that control this are “users” and “customers”.

When a user logs in their username and password are checked and then the application they are accessing determines the directory they will work in.

ubCustomerUpdate

Manage application customers. Use this command to add, change, and delete customers.

• –command
  • add
    • Add a new customer
  • change
    • New email address
  • delete
    • remove customer (but not data – this must be done manually)
  • exists
    • 1 if customer exists, 0 if not
  • get
    • get company ID
• –customer <name>
  • Name of customer to use for command
• –email
  • email address

ubUserUpdate

• –application
  • application name
• –command
  • add
    • add user to customer users for the application
  • change
    • Change user’s email address
  • delete
    • Remove user from customer application
  • exists
    • 1 if user exists, 0 if not
  • get
    • get userId for user
• –directory
  • Working directory for this user and application
• –email
  • User’s email address
• –user
  • user login name

ubDumpTable

Dump contents of customers or users

ubDumpTable <customers|users>

You can add some extra flags such as -A or -m