How to set Default value as Current user for a Column while creating the Table

Help
1

Hi Team

How to set default value as current_user or session_user in a table creation? I know we can do it for timestamp columns but this does not work. Also, since triggers are not supported here, how to acheive this functionality. Please provide some insights.

column1 VARCHAR(32) NOT NULL DEFAULT current_user() ,

2

Only certain default expressions like current_timestamp() are supported, current_user() is not supported as a default expression.

There isn’t an easy way to do this, other than having your insert/load statements set column1 = current_user().