#Apex sql insert action windows#
When the target type is the application log, use Windows Event Viewer to read the results
Reading the SQL Server Audit information from the application log Expand the Security folder in Object ExplorerĪll entries in the *.sqlaudit file will be shown in Log File Viewer, with details for each event in the lower pane.The information retrieved is the same as with the fn_get_audit_file function II Using the Log File Viewer utility in SQL Server Management Studio It doesn’t show the rows affected and the new values, so it cannot be determined what and how was changed Unlike SELECT, INSERT, DROP TABLE actions shown above, where the T-SQL returned by the function is the same as the statement executed, the T-SQL statement for UPDATEs is different. For example, the following is saved when the SQL Server audit object named AdventureWorksAudit_DDL_Access is manually enabled The actual audit feature change (action_id = ‘AUSC’ is stored as XML in the additional_information column. The action_id = ‘SL’ shows SELECT statements executed, ‘IN’ – inserts, ‘DR’ – dropped objects, ‘LGIF’ – failed logins, ‘%AU%’ – events related to the audit feature, and ‘UP’ – updates fn_get_audit_file ( 'D:\TestAudits\*.sqlaudit', DEFAULT, DEFAULT ) WHERE action_id IN ( 'SL', 'IN', 'DR', 'LGIF', '%AU%' )Īs SCHEMA_OBJECT_ACCESS_GROUP was defined on the database-level, all SELECTs executed on any database table are audited ,session_server_principal_name AS UserNameįROM sys. We’ll show what information is captured for the following events:Ī SELECT statement on a table, as a part of the SCHEMA_OBJECT_ACCESS_GROUP Audit Action Type in the Database audit specification Statement – the T-SQL statement that triggered the event, if applicableĪdditional_information –additional information is stored as XML, if existsįile_name – the path and name of the sqlaudit file read Object_name – the object name where the event occurred Schema_name – the schema name where the event occurred Server_instance_name – the SQL Server instance name where the event occurredĭatabase_name – the name of the database where the event occurred
Server_principal_sid – the security ID of the current SQL Server loginĭatabase_principal_name – the current database user Server_principal_name – the current SQL Server login Session_server_principal_name – the SQL Server session login Target_database_principal_id – the database user GRANT/REVOKE/DENY is performed on, 0 if not applicable Target_server_principal_id – the login that GRANT/REVOKE/DENY is performed on, 0 if not applicable Object_ id – the ID of the object (server object, database, database object, or schema object) affected by the event Server_principal_id – the ID of the SQL Server loginĭatabase_principal_id – the ID of the database user Session_id – the ID of the session when the event occurred Is_column_permission – a bit value indicates a column level permission 1 = True, 0 = False Permission_bitmask – not always applicable, shows the permissions granted, revoked, or denied Succeeded – a bit value that indicates the event status 1 = Success, 0 = Fail Sequence_no – the Log Sequence Number (LSN) of the event For example, a database_name, schema_name, and object_name are not populated when a failed login occurs Įvent_time – the time when the event occurred Some of the columns are not populated if the audited event doesn’t provide this information.
#Apex sql insert action how to#
In this article, we will show what information is captured and how to read it when it’s saved in different target types – a *.sqlaudit file, security log, or application log The information capturedįor all target types, the captured audit information is the same. Var records = gridView.In the previous parts of the SQL Server auditing methods series, we described the SQL Server Audit feature, its characteristics, components, how to configure and use it IG static id is defined as emp var gridView = apex.region( "emp").widget().interactiveGrid( "getViews").grid Clear previous selections, if any $s( "P5_SELECTED_ROWS", "")
0 kommentar(er)
