topic Re: Finding simplified table auditing configure options in mysql in Integration and Testing

Finding simplified table auditing configure options in mysql

jennifervaldez — Fri, 01 Jan 2021 15:20:44 GMT

Hello

I'm creating my first MySQL database although I even have 10+ years in SQL Server. i feel SS has an auditing option which can automatically record the history of all row changes. I'd rather not add the subsequent columns to my MySQL tables b/c this is often data which may be inferred, and thus should be imho:

CreatedBy CreatedDate UpdatedBy UpdatedDate

What are my options for configuring SS to infer the column values listed above?

Re: Finding simplified table auditing configure options in mysql

jennifervaldez — Fri, 01 Jan 2021 15:19:16 GMT

Re: Finding simplified table auditing configure options in mysql

keochauau — Wed, 13 Jan 2021 08:29:51 GMT

^_^

Re: Finding simplified table auditing configure options in mysql

LuisaRey — Tue, 02 Mar 2021 11:11:04 GMT

Sets the audit log encryption password to the argument, stores the password in the MySQL keyring. If encryption is enabled, the function performs a log file rotation operation that renames the current log file and begins a new log file encrypted with the password.

The keyring must be enabled or an error occurs. Any keyring plugin can be used; for instructions, see Section 6.4, “The MySQL Keyring”.

For additional information about audit log encryption, see Encrypting Audit Log Files.

Arguments:

password: The password string. The maximum permitted length is 766 bytes.

Return value:

1 for success, 0 for failure.