Types of Users
Two types of users can connect to the Avalanche warehouse database: native users and single sign-on (SSO) users of systems such as Salesforce (for example, name@company.com) used to access the Avalanche console and create warehouses. For more information, see
Single Sign-on Users vs. Native Users.
Note: Currently SSO users can access only the warehouse database using
Query Editor. SSO users are limited to short names (schema name) of 32 characters and long names of 160 characters, both including quotes; for more information, see
ALTER USER, LONG_NAME parameter.
Adding SSO users at warehouse creation time to the dbadmingrp ensures that they have privileges to data granted to dbadmingrp. To ensure all dbadmingrp members have access to the data, grant all privileges on a table to the group dbadmingrp after the table is created by either an SSO or native warehouse user.
The warehouse owner (SSO user) and dbuser are part of dbadmingrp by default.
Related topics:
Last modified date: 01/18/2023