Skip to main content

uqa_engine/open/
authenticated_session.rs

1//
2// Unified Query Algebra
3//
4// Copyright (c) 2023-2026 Cognica, Inc.
5//
6
7//! Establish an independently authenticated database session.
8
9use 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    /// Open an independent session for a role authenticated by the embedding host. This checks role existence, LOGIN, and database CONNECT privileges; credential verification and connection limits belong to the host's connection manager.
18    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}