maria-discuss team mailing list archive
-
maria-discuss team
-
Mailing list archive
-
Message #05715
How to give user permission to create a trigger?
-
To:
"maria-discuss@xxxxxxxxxxxxxxxxxxx" <maria-discuss@xxxxxxxxxxxxxxxxxxx>
-
From:
Thomas Plant <thomas@plant.systems>
-
Date:
Mon, 24 Feb 2020 13:22:52 +0100
-
Arc-authentication-results:
i=1; ORIGINATING; auth=pass smtp.auth=thomas@plant.systems smtp.mailfrom=thomas@plant.systems
-
Arc-message-signature:
i=1; a=rsa-sha256; c=relaxed/relaxed; d=plant.systems; s=2018-10; t=1582546974; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding; bh=oFn7gMOplGxfrd6kOnaatzuU7dKPApwB4ZkRjHQvaYU=; b=ezgv2U5aFpAzqhnXM8mqyH4GMbvnO9VfZYvU1vW0k7zIRuAwVbZ7viAGqZn3WCRVtuhsJN 4gLyxyy8Rz1apGMof6E+GyOxlEh06VWJ56cd/cQcf1i3s7SoZgiBJkq1pyJu1OCjgGdjA+ YwmJv9nOEqtIIh4S2mtMZED/X8ds2MM2ofYSKnbJukTyWlEqTQH9Zou8sc4+1es1WpDdvd iJFFAkdkKYpgwUo5h+OhU5FntFUuhH/h/LOHZgSlXV69AH0sduk4qlM4J9TwgTgzZjivdo 5/GYM2d7ZQTAVHl6ccXl/eBNZoQ/Bsqy0tIJCxrSgKdAHm7qC3V1MDWbAhdEVQ==
-
Arc-seal:
i=1; s=2018-10; d=plant.systems; t=1582546974; a=rsa-sha256; cv=none; b=3Zv3Vt8yYvukcn50syeCpDhFe4TU0o8Bqw6rzashvdOWYbxJeBQ8yE1fepsu5XUklLzGn6 Yd/YhG1rOAwDXEO9sBYNIMxDGVlzsZHpeJQVTi+9QiZAO/DQXWUm7+eubuMPuV8cyAmo2j pipYE5kEaK5qhu2ktEAzFtgbVS95A6ygKbLloiIzc7uujCxp+iqUmhE8W0FtLB+7KDRKCF zk4nCrmltl7aftOiH7AhdKX0U4EE+5dykdZZY485ccg1KWQ0cMRPwnATQHiLV9LRXLpkA+ kyZFcXdDZoDjT3S1y6VLr73KY0tV7PiFu8rVsGRiwA/a7SFRCe/1HZEAIzy8vA==
-
Authentication-results:
ORIGINATING; auth=pass smtp.auth=thomas@plant.systems smtp.mailfrom=thomas@plant.systems
-
User-agent:
Mozilla/5.0 (Windows NT 10.0; WOW64; rv:68.0) Gecko/20100101 Thunderbird/68.5.0
Hello,
we have a MariaDB 10.1 installation used for our shared hosting with a
Master/Slave Replication to another MariaDB 10.1.
One of our customers has a CMS that needs to create a trigger during
installation and errors out about missing permission to create the trigger.
I've 'googled' around and found only that granting 'SUPER' privileges
does resolve this, but we can't give the customer so far reaching
privileges. He is not the only using this server.
Tried to do a 'grant trigger ....' for this user, the command returns
without error, but the grant trigger does not show up in 'show
grants....'. Probably because he as already 'all privileges' granted?
Is there a way to resolve this?
Kind Regards,
Thomas
Follow ups
