Create Profiles and Roles in Teradata VantageCloud Lake - Creating Profiles and Roles with SQL - Teradata VantageCloud Lake

See User Privileges in the VantageCloud Lake documentation for commonly-assigned privileges for users.

CREATE PROFILE P_profile_name  AS profile ;

CREATE PROFILE "P_Profile" AS
COMPUTE GROUP = compute_group
SPOOL=spool_space,
TEMPORARY=NULL,
ACCOUNT=('account__strA',' account_strB'),
DEFAULT DATABASE="database_name",
PASSWORD =
(EXPIRE=90,MINCHAR=NULL,MAXCHAR=NULL,MAXLOGONATTEMPTS=NULL,
LOCKEDUSEREXPIRE=NULL,REUSE=NULL,DIGITS=NULL,
RESTRICTWORDS=NULL,SPECCHAR=NULL);

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

1. Create the role. Best practice is to start the role name with R_ to make it easily identifiable as a role.

   CREATE ROLE R_role_name;
   

2. Assign privileges to the role.

   GRANT privilege_list
   ON database_object_name
   TO R_role_name;

3. Include privileges on Sys_Calendar to the role.

    GRANT SELECT, EXECUTE ON Sys_Calendar TO R_role_name;

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