uqa_engine/open/
authenticated_session.rs1use uqa_sql::ast::RoleAttribute;
10use uqa_sql::catalog::roles::{identity::RoleBinding, session::SessionAuthorization};
11use uqa_sql::SQLError;
12
13use crate::Engine;
14use uqa_sql::catalog::security::database::DatabaseAclPrivilege;
15
16impl Engine {
17 pub fn new_session_for_user(&self, user: &str) -> Result<Self, SQLError> {
19 let session = self
20 .new_session()
21 .map_err(|error| SQLError::Internal(format!("open authenticated session: {error}")))?;
22 let identity = {
23 let roles = session.durable.roles.read();
24 let role = roles.get(user).ok_or_else(|| SQLError::Routine {
25 sqlstate: "28000".into(),
26 message: format!("role \"{user}\" does not exist"),
27 })?;
28 if !role.has(RoleAttribute::Login) {
29 return Err(SQLError::Routine {
30 sqlstate: "28000".into(),
31 message: format!("role \"{user}\" is not permitted to log in"),
32 });
33 }
34 RoleBinding::from_definition(role)?
35 };
36 session.ensure_database_privilege(&identity, DatabaseAclPrivilege::Connect)?;
37 {
38 let mut state = session.session.state.write();
39 state.authorization = SessionAuthorization::new(identity);
40 state.sql_statement_cache.clear();
41 }
42 Ok(session)
43 }
44}