github.com/matrixorigin/matrixone@v0.7.0/test/distributed/cases/function/account_info_func.result (about) 1 select current_account_name(); 2 current_account_name() 3 sys 4 select current_account_id(); 5 current_account_id() 6 0 7 select current_user_name(); 8 current_user_name() 9 dump 10 select current_user_id(); 11 current_user_id() 12 1 13 select current_role_name(); 14 current_role_name() 15 moadmin 16 select current_role_id(); 17 current_role_id() 18 0 19 select * from current_account() as t; 20 account_name account_id user_name user_id role_name role_id 21 sys 0 dump 1 moadmin 0 22 drop account if exists abc; 23 create account abc ADMIN_NAME 'admin' IDENTIFIED BY '123456'; 24 drop role if exists test_role; 25 create role test_role; 26 grant test_role to admin; 27 set role test_role; 28 select current_account_name(); 29 current_account_name() 30 abc 31 select current_user_name(); 32 current_user_name() 33 abc:admin 34 select current_user_id(); 35 current_user_id() 36 2 37 select current_role_name(); 38 current_role_name() 39 test_role