title: Ð Ð°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ° Ð¸ Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ðµ Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ð½ÑÑ ÑÑÐµÐ´ÑÑÐ² Ð°ÑÐ´Ð¸ÑÐ° Ð´ÐµÐ¹ÑÑÐ²Ð¸Ð¹ Ð¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°ÑÐµÐ»Ñ Ð¡Ð£ÐÐ PostgreSQL
title: Ð²ÑÐ¿ÑÑÐºÐ½Ð°Ñ ÐºÐ²Ð°Ð»Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¾Ð½Ð½Ð°Ñ ÑÐ°Ð±Ð¾ÑÐ° Ð±Ð°ÐºÐ°Ð»Ð°Ð²ÑÐ°
titleType: Subtitle
title: Development and research of software tools for auditing user actions in the PostgreSQL database
Creators: name: ÐÐ¾Ð´Ð¸Ð½Ð°, ÐÐ»Ð¸Ð·Ð°Ð²ÐµÑÐ°
Publisher: name: Ð¡Ð°Ð½ÐºÑ-ÐÐµÑÐµÑÐ±ÑÑÐ³ÑÐºÐ¸Ð¹ Ð¿Ð¾Ð»Ð¸ÑÐµÑÐ½Ð¸ÑÐµÑÐºÐ¸Ð¹ ÑÐ½Ð¸Ð²ÐµÑÑÐ¸ÑÐµÑ ÐÐµÑÑÐ° ÐÐµÐ»Ð¸ÐºÐ¾Ð³Ð¾
Year: 2024
Subjects: Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ
Ð¼ÐµÑÐ¾Ð´Ñ Ð·Ð°ÑÐ¸ÑÑ Ð¸Ð½ÑÐ¾ÑÐ¼Ð°ÑÐ¸Ð¸ Ð² Ð±Ð°Ð·Ð°Ñ Ð´Ð°Ð½Ð½ÑÑ
Ð°ÑÐ´Ð¸Ñ
Ð°ÑÐ´Ð¸Ñ Ð´ÐµÐ¹ÑÑÐ²Ð¸Ð¹ Ð¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°ÑÐµÐ»Ñ
database
methods of protecting information in database
audit
audit of user actions

description: ÐÐ±ÑÐµÐºÑÐ¾Ð¼ Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ñ ÑÐ²Ð»ÑÐµÑÑÑ Ð¿ÑÐ¾ÑÐµÑÑ Ð°ÑÐ´Ð¸ÑÐ° Ð´ÐµÐ¹ÑÑÐ²Ð¸Ð¹ Ð¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°ÑÐµÐ»Ñ Ð² Ð¡Ð£ÐÐ Oracle Database Ð¸ PostgreSQL. ÐÑÐµÐ´Ð¼ÐµÑ Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ñ â Ð¼ÐµÑÐ¾Ð´Ñ, Ð¾Ð±ÐµÑÐ¿ÐµÑÐ¸Ð²Ð°ÑÑÐ¸Ðµ Ð°ÑÐ´Ð¸Ñ Ð´ÐµÐ¹ÑÑÐ²Ð¸Ð¹ Ð¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°ÑÐµÐ»Ñ Ð² Ð¡Ð£ÐÐ Oracle Database Ð¸ PostgreSQL. Ð¦ÐµÐ»ÑÑ Ð´Ð°Ð½Ð½Ð¾Ð¹ ÑÐ°Ð±Ð¾ÑÑ ÑÐ²Ð»ÑÐµÑÑÑ ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ° Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ñ, Ð²ÑÐ¿Ð¾Ð»Ð½ÑÑÑÐµÐ¹ Ð°ÑÐ´Ð¸Ñ Ð´ÐµÐ¹ÑÑÐ²Ð¸Ð¹ Ð¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°ÑÐµÐ»Ñ Ð² Ð¡Ð£ÐÐ PostgreSQL, Ð° ÑÐ°ÐºÐ¶Ðµ Ð²Ð½ÐµÐ´ÑÐµÐ½Ð¸Ðµ Ð¿Ð¾Ð»ÑÑÐµÐ½Ð½Ð¾Ð¹ Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ñ Ð´Ð»Ñ Ð°Ð²ÑÐ¾Ð¼Ð°ÑÐ¸ÑÐµÑÐºÐ¾Ð³Ð¾ Ð·Ð°Ð¿ÑÑÐºÐ° Ð°ÑÐ´Ð¸ÑÐ°, Ð² ÑÐ¾Ð¾ÑÐ²ÐµÑÑÑÐ²Ð¸Ð¸ Ñ ÑÑÐµÐ±Ð¾Ð²Ð°Ð½Ð¸ÑÐ¼Ð¸ ÑÐ¸ÑÑÐµÐ¼Ñ. Ð Ð´Ð°Ð½Ð½Ð¾Ð¹ ÑÐ°Ð±Ð¾ÑÐµ Ð±ÑÐ»Ð¾ Ð¿ÑÐ¾Ð²ÐµÐ´ÐµÐ½Ð¾ Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ðµ Ð¼ÐµÑÐ¾Ð´Ð¾Ð² Ð°ÑÐ´Ð¸ÑÐ° Ð² Ð¡Ð£ÐÐ Ð¸ ÑÐµÐ°Ð»Ð¸Ð·Ð°ÑÐ¸Ñ Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ñ, Ð¾ÑÑÑÐµÑÑÐ²Ð»ÑÑÑÐµÐ¹ Ð°ÑÐ´Ð¸Ñ Ð´ÐµÐ¹ÑÑÐ²Ð¸Ð¹ Ð¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°ÑÐµÐ»Ñ Ð² Ð¡Ð£ÐÐ PostgreSQL. Ð Ð¿ÐµÑÐ²Ð¾Ð¹ Ð³Ð»Ð°Ð²Ðµ Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ñ ÑÑÑÐµÑÑÐ²ÑÑÑÐ¸Ðµ Ð¼ÐµÑÐ¾Ð´Ñ Ð² Ð¡Ð£ÐÐ Oracle Database Ð¸ PostgreSQL, Ð¿ÑÐ¾Ð²ÐµÐ´ÐµÐ½Ð¾ ÑÑÐ°Ð²Ð½ÐµÐ½Ð¸Ðµ Ð¸ Ð¿Ð¾ÑÑÐ°Ð²Ð»ÐµÐ½Ð° Ð·Ð°Ð´Ð°ÑÐ° Ð½Ð° ÑÐµÐ°Ð»Ð¸Ð·Ð°ÑÐ¸Ñ. ÐÐ¾ Ð²ÑÐ¾ÑÐ¾Ð¹ Ð³Ð»Ð°Ð²Ðµ Ð¾Ð¿Ð¸ÑÐ°Ð½ Ð°Ð»Ð³Ð¾ÑÐ¸ÑÐ¼ ÑÐ¾Ð·Ð´Ð°Ð½Ð¸Ñ ÐºÐ¾Ð´Ð°, Ð¾Ð±ÐµÑÐ¿ÐµÑÐ¸Ð²Ð°ÑÑÐ¸Ð¹ Ð°ÑÐ´Ð¸Ñ Ð´ÐµÐ¹ÑÑÐ²Ð¸Ð¹ Ð¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°ÑÐµÐ»Ñ Ð¸ ÑÐµÐ°Ð»Ð¸Ð·Ð¾Ð²Ð°Ð½Ð° Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ð° Ð´Ð»Ñ Ð°Ð½Ð°Ð»Ð¸Ð·Ð° ÑÑÐ°ÑÐ¸ÑÑÐ¸ÐºÐ¸ Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð² Ð¸ Ð·Ð°Ð¿ÑÑÐºÐ° Ð°ÑÐ´Ð¸ÑÐ° Ð¿Ð¾ ÑÐµÐ·ÑÐ»ÑÑÐ°ÑÐ°Ð¼ Ð°Ð½Ð°Ð»Ð¸Ð·Ð°. Ð ÑÑÐµÑÑÐµÐ¹ Ð³Ð»Ð°Ð²Ðµ Ð¿Ð¾ Ð¿Ð¾Ð»ÑÑÐµÐ½Ð½Ð¾Ð¼Ñ Ð°Ð»Ð³Ð¾ÑÐ¸ÑÐ¼Ñ Ð¿ÑÐ¾Ð²ÐµÐ´ÐµÐ½Ð° ÑÐµÐ°Ð»Ð¸Ð·Ð°ÑÐ¸Ñ ÐºÐ¾Ð´Ð°. Ð ÑÐµÑÐ²ÐµÑÑÐ¾Ð¹ Ð³Ð»Ð°Ð²Ðµ Ð¿ÑÐ¾Ð²ÐµÐ´ÐµÐ½Ð¾ ÑÐµÑÑÐ¸ÑÐ¾Ð²Ð°Ð½Ð¸Ðµ Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ð½Ð¾Ð³Ð¾ ÐºÐ¾Ð´Ð°. Ð ÐµÐ·ÑÐ»ÑÑÐ°ÑÐ¾Ð¼ ÑÐ°Ð±Ð¾ÑÑ ÑÐ²Ð»ÑÐµÑÑÑ Ð½Ð°Ð¿Ð¸ÑÐ°Ð½Ð½ÑÐ¹ Ð¸ Ð¿ÑÐ¾ÑÐµÑÑÐ¸ÑÐ¾Ð²Ð°Ð½Ð½ÑÐ¹ ÐºÐ¾Ð´, Ð¾Ð±ÐµÑÐ¿ÐµÑÐ¸Ð²Ð°ÑÑÐ¸Ð¹ Ð°ÑÐ´Ð¸Ñ Ð´ÐµÐ¹ÑÑÐ²Ð¸Ð¹ Ð¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°ÑÐµÐ»Ñ Ð² Ð±Ð°Ð·Ðµ Ð´Ð°Ð½Ð½ÑÑ. ÐÐ°Ð»ÑÐ½ÐµÐ¹ÑÐ¸Ðµ Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ñ Ð¼Ð¾Ð³ÑÑ Ð±ÑÑÑ Ð½Ð°Ð¿ÑÐ°Ð²Ð»ÐµÐ½Ñ Ð½Ð° ÑÐ°Ð·Ð²Ð¸ÑÐ¸Ðµ Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ñ Ð´Ð»Ñ Ð±Ð¾Ð»ÑÑÐµÐ¹ Ð²Ð°ÑÐ¸Ð°ÑÐ¸Ð¸ ÐºÐ¾Ð¼Ð°Ð½Ð´, Ð° ÑÐ°ÐºÐ¶Ðµ Ð²Ð½ÐµÐ´ÑÐµÐ½Ð¸Ðµ Ð¿Ð¾Ð»ÑÑÐµÐ½Ð½Ð¾Ð³Ð¾ ÐºÐ¾Ð´Ð° Ð² Ð´ÑÑÐ³Ð¸Ðµ Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ñ.
description: The object of the study is the process of auditing user actions in the Oracle Database and PostgreSQL databases. The subject of the study is methods for auditing user actions in Oracle Database and PostgreSQL databases. The purpose of this work is to develop a program that performs an audit of user actions in the PostgreSQL database, as well as the implementation of the resulting program to automatically start the audit, in accordance with the requirements of the system. In this paper, we conducted a study of audit methods in the DBMS and the implementation of a program that audits user actions in the PostgreSQL DBMS. The first chapter examines the existing methods in the Oracle Database and PostgreSQL databases, compares them and sets the task for implementation. The second chapter describes the algorithm for creating code that provides audit of user actions and implements a program for analyzing query statistics and launching an audit based on the results of the analysis. In the third chapter, the code was implemented using the resulting algorithm. In the fourth chapter, the program code is tested. The result of the work is written and tested code that provides audit of user actions in the database. Further research may be aimed at developing the program for greater command variation, as well as implementing the resulting code into other programs.