uqa-sql 0.5.0

PostgreSQL-compatible SQL compiler built on libpg_query
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32

//
// Unified Query Algebra
//
// Copyright (c) 2023-2026 Cognica, Inc.
//

//! The warning of a `GRANT` or `REVOKE` that changes fewer privileges than it names.

use crate::SQLNotice;

/// The warning `PostgreSQL`'s `restrict_and_check_grant` reports when the grantor holds the grant option for none of the privileges a `GRANT` or `REVOKE` of `name` names, or, when `partial`, for only some of them: SQLSTATE `01007` (`warning_privilege_not_granted`) for a grant and `01006` (`warning_privilege_not_revoked`) for a revocation.
pub fn acl_warning(is_grant: bool, partial: bool, name: &str) -> SQLNotice {
    let (message, sqlstate) = match (is_grant, partial) {
        (true, true) => (
            format!("not all privileges were granted for \"{name}\""),
            "01007",
        ),
        (true, false) => (
            format!("no privileges were granted for \"{name}\""),
            "01007",
        ),
        (false, true) => (
            format!("not all privileges could be revoked for \"{name}\""),
            "01006",
        ),
        (false, false) => (
            format!("no privileges could be revoked for \"{name}\""),
            "01006",
        ),
    };
    SQLNotice::warning(message).with_sqlstate(sqlstate)
}