1. proflie advantages
You can use profile to manage USER Parameters in batches, especially when a group of users have the same parameter configuration.
2. configurable user parameters for profile
[Account ID] [default database]: takes effect the next time you log on or submit the set session account command.
[Spool space] [temporary space]: takes effect immediately.
[Password]: The password takes effect upon next login.
3. grant permissions to the proflie operation
Grant CreateProfile,DropProfileToCitic_edwWith Grant Option;
4. create, modify, and delete a query, proflie (profileemployee_p)
Create profile employee_p as account = '' ; Modify Profile employee_p as account = '' ; drop profile employee_p; select * from DBC. profileinfov; -- View profile information
select * from DBC. accountinfov; -- view User Account Information
select User, role, profile, database; -- view the current user information
5. the user uses the specified profile (profileemployee_p or null)
Create UserEmp01As..., Profile=Employee_p; modifyUserEmp02AsProfile=Employee_p; modifyUserEmp03AsProfile=Null;
6. Priority of USER Parameters
(1) Specify the database or account ID at the session level
(2) User parameters specified in profile
(3) User parameters specified by the create user or modify user statement
7. Create a complete profile instance
Create Profile employee_p As Account = ( ' $ M0_educ & S & D & H ' , ' $ L0_educ & S & D & H ' ) Default Database = Hr_vm Spool = 1e9 Temporary = 500e6 Password = (Expire = 90 , Minchar = 8 , Maxlogonattempts = 3 , Lockeduserexpire = 60 , Reuse = 180 , Digits = ' R ' , Restrictwords = ' Y ' , Specchar = ' P ' );
Use teradata profile