When entering the SQL for a datasource in the Pentaho User Console, are there any environmental variables, parameters, etc. that can be included in the query? If so, is the syntax something like:
SELECT * FROM data WHERE allowed_users IN (${role})

Is there a variable for user/login?