0

I have created a sample user with the following request:

grant select, insert, update, delete on db.* to user@localhost identified by 'pass';

but that user does also need permission to use start transaction and commit. Which is the suitable permission to allow both commands?

masegaloeh
  • 18,236
  • 10
  • 57
  • 106
ABu
  • 499
  • 1
  • 6
  • 19

1 Answers1

3

This doesn't require a specific privilege, as a transaction just groups a number of database operations into one to maintain consistency. All you need is to have the privileges to do all operations within the transaction.

Please take the time to actually read the MySQL documentation.

Sven
  • 98,649
  • 14
  • 180
  • 226
  • The documentation is "too" huge, and I've searched on the Oracle docs, and, appart from receiving more articles in French and Japanese than in English, I have found nothing relating transactions and permission together. And altough I know a transaction is a package of operations, I didn't know if transaction operations are considered a sort of built-in procedures or something like that. – ABu Oct 10 '14 at 08:35