Function act_grant_revoke

src/gpre/sql.cpp:3142–3363

//

static act* act_grant_revoke(act_t type)
{
	gpre_req* request = MSC_request(REQ_ddl);
	PRV priv_block = MSC_privilege_block();

	// if it is revoke action, parse the optional grant option for

	if (type == ACT_dyn_revoke)
	{
		if (MSC_match(KW_GRANT))
		{
			if (!MSC_match(KW_OPTION))
				CPR_s_error("OPTION");
			if (!MSC_match(KW_FOR))
				CPR_s_error("FOR");
			priv_block->prv_privileges |= PRV_grant_option;
		}
	}

	bool execute_priv = false;

	if (MSC_match(KW_ALL))
	{
		MSC_match(KW_PRIVILEGES);	// Keyword 'privileges' is optional
		priv_block->prv_privileges = PRV_all;
	}
	else if (MSC_match(KW_EXECUTE))
	{
		priv_block->prv_privileges |= PRV_execute;
		execute_priv = true;
	}
	else
	{
		gpre_lls** fields = &priv_block->prv_fields;
		while (true)
		{
			if (MSC_match(KW_SELECT))
				priv_block->prv_privileges |= PRV_select;
			else if (MSC_match(KW_INSERT))
				priv_block->prv_privileges |= PRV_insert;
			else if (MSC_match(KW_DELETE))
				priv_block->prv_privileges |= PRV_delete;
			else if (MSC_match(KW_UPDATE))
			{
				priv_block->prv_privileges |= PRV_update;
				if (MSC_match(KW_LEFT_PAREN))
				{
					SCHAR col_name[NAME_SIZE + 1];
					do {
						SQL_resolve_identifier("<column name>", col_name, NAME_SIZE + 1);
						if (gpreGlob.token_global.tok_length >= NAME_SIZE)
							PAR_error("Field name too long");

						STR field_name = (STR) MSC_string(col_name);
						MSC_push((gpre_nod*) field_name, fields);
						fields = &(*fields)->lls_next;
						CPR_token();
					} while (MSC_match(KW_COMMA));