[SPARK-44860] Implement SESSION_USER function

• Type: Task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.0.0
• Fix Version/s: 4.0.0
• Component/s: SQL
• Assignee: Vitalii Li
• Reporter: Vitalii Li
• Created: 17/Aug/23 23:15
• Updated: 29/Aug/23 02:43
• Resolved: 29/Aug/23 02:43

Description

According to SQL standard SESSION_USER and CURRENT_USER behavior differs for routines:

• CURRENT_USER inside a routine should return security definer of a routine, e.g. owner identity
• SESSION_USER inside a routine should return connected user.

Issue Links

• links to: [Github] Pull Request #42549 (vitaliili-db)
• links to: [Github] Pull Request #42549 (vitaliili-db)