Struct grant::config::role::RoleTableLevel

pub struct RoleTableLevel {
    pub name: String,
    pub grants: Vec<String>,
    pub schemas: Vec<String>,
    pub tables: Vec<String>,
}

Role Table Level.

For example:

- name: role_table
  grants:
    - SELECT
    - INSERT
    - UPDATE
    - DELETE
  schemas:
  - public
  tables:
    - ALL
    - +table1
    - -table2
    - -public.table2

The above example grants SELECT, INSERT, UPDATE, DELETE to all tables in the public schema except table2. The ALL is a special keyword that means all tables in the public schema. If the table does not have a schema, it is assumed to be in all schema.

Fields

name: String

grants: Vec<String>

schemas: Vec<String>

tables: Vec<String>

Implementations

impl RoleTableLevel

pub fn to_sql(&self, user: &str) -> String

Generate role table to sql.

{GRANT | REVOKE} { { SELECT | INSERT | UPDATE | DELETE | DROP | REFERENCES } [,...] | ALL [ PRIVILEGES ] }
ON { [ TABLE ] table_name [, ...] | ALL TABLES IN SCHEMA schema_name [, ...] }
TO { username [ WITH GRANT OPTION ] | GROUP group_name | PUBLIC } [, ...]

Trait Implementations

impl Clone for RoleTableLevel

fn clone(&self) -> RoleTableLevel

Returns a copy of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for RoleTableLevel

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl<'de> Deserialize<'de> for RoleTableLevel

fn deserialize<__D>(__deserializer: __D) -> Result<Self, __D::Error>

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl PartialEq for RoleTableLevel

fn eq(&self, other: &RoleTableLevel) -> bool

This method tests for self and other values to be equal, and is used by ==.

fn ne(&self, other: &Rhs) -> bool

This method tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.

impl RoleValidate for RoleTableLevel

fn validate(&self) -> Result<()>

impl Serialize for RoleTableLevel

fn serialize<__S>(&self, __serializer: __S) -> Result<__S::Ok, __S::Error>

where __S: Serializer,

Serialize this value into the given Serde serializer.

impl Eq for RoleTableLevel

impl StructuralPartialEq for RoleTableLevel