iffyio commented on code in PR #2035:
URL:
https://github.com/apache/datafusion-sqlparser-rs/pull/2035#discussion_r2372043660
##########
src/ast/mod.rs:
##########
@@ -10558,6 +10564,199 @@ impl fmt::Display for CreateUser {
}
}
+/// Modifies the properties of a user
+///
+/// Syntax:
+/// ```sql
+/// ALTER USER [ IF EXISTS ] [ <name> ] [ OPTIONS ]
+/// ```
+///
+/// [Snowflake](https://docs.snowflake.com/en/sql-reference/sql/alter-user)
+#[derive(Debug, Clone, PartialEq, PartialOrd, Eq, Ord, Hash)]
+#[cfg_attr(feature = "serde", derive(Serialize, Deserialize))]
+#[cfg_attr(feature = "visitor", derive(Visit, VisitMut))]
+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 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>,
Review Comment:
@yoavcloud one thing I realised now with these props, could we add a link
tho the snowflake docs individually for them? Thinking so that when new options
are inevitably added for other dialects it would be clear where each propery
comes from
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org
For additional commands, e-mail: github-h...@datafusion.apache.org
