CURRENT_USER/SESSION_USER should be special keywords, but our current syntax treats them as normal strings. Consider the following example using the ALTER SCHEMA command:
root@127.0.0.1:61524/movr> alter schema sc OWNER TO CURRENT_USER;
ERROR: role/user "current_user" does not exist
SQLSTATE: 42704
root@127.0.0.1:61524/movr> alter schema sc OWNER TO SESSION_USER;
ERROR: role/user "session_user" does not exist
SQLSTATE: 42704
root@127.0.0.1:61524/movr> alter schema sc OWNER TO admin;
ALTER SCHEMA
Time: 0.029s total (exec 10.2% / net 88.2% / other 1.6%)
Epic CRDB-8948
CURRENT_USER/SESSION_USERshould be special keywords, but our current syntax treats them as normal strings. Consider the following example using theALTER SCHEMAcommand:Epic CRDB-8948