Reply
Member
Posts: 3
Registered: ‎12-25-2020

Finding simplified table auditing configure options in mysql

[ Edited ]

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?

Member
Posts: 3
Registered: ‎12-25-2020

Re: Finding simplified table auditing configure options in mysql

:)

Member
Posts: 1
Registered: ‎01-13-2021

Re: Finding simplified table auditing configure options in mysql

^_^

Member
Posts: 2
Registered: ‎02-13-2021

Re: Finding simplified table auditing configure options in mysql

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.