Struct AlterUser 

pub struct AlterUser {

    pub if_exists: bool,
    pub name: Ident,
    pub rename_to: Option<Ident>,
    pub reset_password: bool,
    pub abort_all_queries: bool,
    pub add_role_delegation: Option<AlterUserAddRoleDelegation>,
    pub remove_role_delegation: Option<AlterUserRemoveRoleDelegation>,
    pub enroll_mfa: bool,
    pub set_default_mfa_method: Option<MfaMethodKind>,
    pub remove_mfa_method: Option<MfaMethodKind>,
    pub modify_mfa_method: Option<AlterUserModifyMfaMethod>,
    pub add_mfa_method_otp: Option<AlterUserAddMfaMethodOtp>,
    pub set_policy: Option<AlterUserSetPolicy>,
    pub unset_policy: Option<UserPolicyKind>,
    pub set_tag: KeyValueOptions,
    pub unset_tag: Vec<String>,
    pub set_props: KeyValueOptions,
    pub unset_props: Vec<String>,
    pub password: Option<AlterUserPassword>,
}

Modifies the properties of a user

Snowflake Syntax:

ALTER USER [ IF EXISTS ] [ <name> ] [ OPTIONS ]

PostgreSQL Syntax:

ALTER USER <role_specification> [ WITH ] option [ ... ]

Fields

if_exists: bool

Whether to only alter the user if it exists.

name: Ident

The name of the user to alter.

rename_to: Option<Ident>

Optional new name for the user (Snowflake-specific). See: https://docs.snowflake.com/en/sql-reference/sql/alter-user#syntax

reset_password: bool

Reset the user’s password.

abort_all_queries: bool

Abort all running queries for the user.

add_role_delegation: Option<AlterUserAddRoleDelegation>

Optionally add a delegated role authorization.

remove_role_delegation: Option<AlterUserRemoveRoleDelegation>

Optionally remove a delegated role authorization.

enroll_mfa: bool

Enroll the user in MFA.

set_default_mfa_method: Option<MfaMethodKind>

Set the default MFA method for the user.

remove_mfa_method: Option<MfaMethodKind>

Remove the user’s default MFA method.

modify_mfa_method: Option<AlterUserModifyMfaMethod>

Modify an MFA method for the user.

add_mfa_method_otp: Option<AlterUserAddMfaMethodOtp>

Add an MFA OTP method with optional count.

set_policy: Option<AlterUserSetPolicy>

Set a user policy.

unset_policy: Option<UserPolicyKind>

Unset a user policy.

set_tag: KeyValueOptions

Key/value tag options to set on the user.

unset_tag: Vec<String>

Tags to unset on the user.

set_props: KeyValueOptions

Key/value properties to set on the user.

unset_props: Vec<String>

Properties to unset on the user.

password: Option<AlterUserPassword>

The following options are PostgreSQL-specific: https://www.postgresql.org/docs/current/sql-alteruser.html

Trait Implementations

impl Clone for AlterUser

fn clone(&self) -> AlterUser

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for AlterUser

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

Formats the value using the given formatter.

impl Display for AlterUser

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

Formats the value using the given formatter.

impl Eq for AlterUser

impl From<AlterUser> for Statement

fn from(a: AlterUser) -> Statement

Converts to this type from the input type.

impl Hash for AlterUser

fn hash<__H>(&self, state: &mut __H)

where __H: Hasher,

Feeds this value into the given Hasher.

fn hash_slice<H>(data: &[Self], state: &mut H)

where H: Hasher, Self: Sized,

Feeds a slice of this type into the given Hasher.

impl Ord for AlterUser

fn cmp(&self, other: &AlterUser) -> Ordering

This method returns an Ordering between self and other.

fn max(self, other: Self) -> Self

where Self: Sized,

Compares and returns the maximum of two values.

fn min(self, other: Self) -> Self

where Self: Sized,

Compares and returns the minimum of two values.

fn clamp(self, min: Self, max: Self) -> Self

where Self: Sized,

Restrict a value to a certain interval.

impl PartialEq for AlterUser

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

Tests for self and other values to be equal, and is used by ==.

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

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

impl PartialOrd for AlterUser

fn partial_cmp(&self, other: &AlterUser) -> Option<Ordering>

This method returns an ordering between self and other values if one exists.

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

Tests less than (for self and other) and is used by the < operator.

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

Tests less than or equal to (for self and other) and is used by the <= operator.

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

Tests greater than (for self and other) and is used by the > operator.

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

Tests greater than or equal to (for self and other) and is used by the >= operator.

impl StructuralPartialEq for AlterUser

impl Visit for AlterUser

fn visit<V>(&self, visitor: &mut V) -> ControlFlow<<V as Visitor>::Break>

where V: Visitor,

Visit this node with the provided Visitor.

impl VisitMut for AlterUser

fn visit<V>(&mut self, visitor: &mut V) -> ControlFlow<<V as VisitorMut>::Break>

where V: VisitorMut,

Mutably visit this node with the provided VisitorMut.