cancel
Showing results for 
Search instead for 
Did you mean: 

Finding simplified table auditing configure options in mysql

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?

3 REPLIES 3

:)

^_^

keochauau
Member

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.

LuisaRey
Member