Create Database Users with SQL | Teradata VantageCloud Lake - Creating Database Users with SQL - Teradata VantageCloud Lake

Create users:

1. Create a user, and include their additional privileges and the default role.
   Include the default compute group if the compute profile does not include the default compute group.

   CREATE USER "user_name" FROM SYSDBA
   AS PERM = number_of_bytes,
   PASSWORD = "temp_password",
   STARTUP = '',
   DEFAULT DATABASE = "database_name",
   PROFILE="P_profile_name”,
   DEFAULT ROLE = All,
   [ COMPUTE GROUP = "compute_group" ] ;

   Important: If you create users outside of the VantageCloud Lake platform, then you must grant those users the following privileges to allow them to access the platform:

   GRANT ALL ON user_name to user_name WITH GRANT OPTION
   GRANT LOGON ON ALL TO user_name WITH NULL PASSWORD

   See CREATE USER in the VantageCloud Lake documentation for additional information.

2. Grant one or more roles to the user.

   GRANT R_role_name TO user_name;

   Grant user access to the compute group if the role privileges did not include access.