Manage Organizations

About Organizations and Users

SingleStore organizations allow shared access to deployments and resources within a company or group. A default organization is automatically created when a user registers on the Cloud Portal. A user cannot create or rename the organization.

You can view and manage an organization from the organization list at the top. It includes the following:

• Current Organization

• Billing & Usage

• Users & Teams

• Licenses

• Organization Details

• User Settings

To view and manage the deployments within an organization, select Deployments on the left navigation pane. The Deployments page includes the following:

• Overview 

• Workspaces

• Databases

• User Management

• Stage

• Access

• Firewall

• Security

• Updates

Each organization must have a billing account to create workspaces and databases. The billing account is used to pay for on-demand usage, or to pay for credits subscriptions and storage usage. Additional billing accounts can also be added, but only the default billing method will be charged for usage.

A user is an Individual who logs into the Cloud Portal and can access portal services. Each user is associated with a default organization and automatically has access to all the resources within that organization. While most users will have one organization for their company, they can belong to, and be removed from, multiple organizations. An organization allows multiple users within a company to manage resources and databases affiliated with that organization. Users are common for all the databases within a workspace group. Privileges should be used to separate access.

A separate admin user is created while provisioning a database. A password is specifically set for the admin user.

Cloud Portal users can access the database only in the Cloud Portal SQL Editor and Notebooks. They cannot access the workspace via CLI or IDE tools. To access the database directly using the workspace endpoints use the admin user or create a separate database user.

The admin user can log in using CLI or IDE tools.

Each organization user is an administrator of that organization. A user that has admin permissions on an organization can:

• Add users to, and remove users from, the organization

• Manage billing and payment methods within the organization

• Create resources (workspaces, databases) within the organization

• Manage/terminate resources (workspaces, databases) within the organization

Cloud Portal users and the admin user are automatically granted the following access. These permissions need not be explicitly granted.

SHOW GRANTS

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, INDEX, ALTER, SHOW METADATA, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, ALTER VIEW, DROP VIEW, BACKUP, CREATE DATABASE, DROP DATABASE, CREATE PIPELINE, DROP PIPELINE, START PIPELINE, ALTER PIPELINE, SHOW PIPELINE, CREATE LINK, DROP LINK, SHOW LINK, DROP POOL, CREATE POOL ON *.* TO 'admin'@'%' IDENTIFIED BY PASSWORD <secret> WITH GRANT OPTION

Any user can manage billing accounts as needed. To add a billing account, select the organization name at the top, and then navigate to <your_organisation> > Billing & Usage. Select the + Add Payment Method button, and provide the required information. Alternatively, you can select + Add Payment Method on the Payment Methods tab.

A user’s organization is shown at the top. If a user is a member of multiple organizations, they may select the desired organization from the Current Organization list.