Method parse_alter_default_privileges

src/sql-parser/src/parser.rs:6402–6467

(&mut self)

    }

    fn parse_alter_default_privileges(&mut self) -> Result<Statement<Raw>, ParserError> {
        self.expect_keyword(FOR)?;
        let target_roles = match self.expect_one_of_keywords(&[ROLE, USER, ALL])? {
            ROLE | USER => TargetRoleSpecification::Roles(
                self.parse_comma_separated(Parser::parse_identifier)?,
            ),
            ALL => {
                self.expect_keyword(ROLES)?;
                TargetRoleSpecification::AllRoles
            }
            _ => unreachable!(),
        };
        let target_objects = if self.parse_keyword(IN) {
            match self.expect_one_of_keywords(&[SCHEMA, DATABASE])? {
                SCHEMA => GrantTargetAllSpecification::AllSchemas {
                    schemas: self.parse_comma_separated(Parser::parse_schema_name)?,
                },
                DATABASE => GrantTargetAllSpecification::AllDatabases {
                    databases: self.parse_comma_separated(Parser::parse_database_name)?,
                },
                _ => unreachable!(),
            }
        } else {
            GrantTargetAllSpecification::All
        };
        let is_grant = self.expect_one_of_keywords(&[GRANT, REVOKE])? == GRANT;
        let privileges = self.parse_privilege_specification().ok_or_else(|| {
            self.expected::<_, PrivilegeSpecification>(
                self.peek_pos(),
                "ALL or INSERT or SELECT or UPDATE or DELETE or USAGE or CREATE",
                self.peek_token(),
            )
            .expect_err("only returns errors")
        })?;
        self.expect_keyword(ON)?;
        let object_type =
            self.expect_grant_revoke_plural_object_type(if is_grant { "GRANT" } else { "REVOKE" })?;
        if is_grant {
            self.expect_keyword(TO)?;
        } else {
            self.expect_keyword(FROM)?;
        }
        let grantees = self.parse_comma_separated(Parser::expect_role_specification)?;

        let grant_or_revoke = if is_grant {
            AbbreviatedGrantOrRevokeStatement::Grant(AbbreviatedGrantStatement {
                privileges,
                object_type,
                grantees,
            })
        } else {
            AbbreviatedGrantOrRevokeStatement::Revoke(AbbreviatedRevokeStatement {
                privileges,
                object_type,
                revokees: grantees,
            })
        };