database security Archives - {coding}Sight https://codingsight.com/tag/database-security/ Blog for SQL Server DBAs and Developers Sat, 12 Aug 2023 07:11:34 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://codingsight.com/wp-content/uploads/2021/10/cropped-Soсial_-Fb_180х180-1-32x32.png database security Archives - {coding}Sight https://codingsight.com/tag/database-security/ 32 32 Understanding SQL Server Security Function HAS_Permis_BY_Name and Its USE Cases https://codingsight.com/understanding-sql-server-security-function-has_permis_by_name-and-its-use-cases/ Mon, 30 Aug 2021 07:45:44 +0000 http://codingsight.com/?p=16429 There are multiple instances when we want to check the permission on a securable for a principal. Before going ahead, let’s see what principal, securables, and permissions are. According to Microsoft Documentation, Securables in SQL Server context are specific resources to which the SQL Server Database Engine authorization system controls access. They are divided into …

The post Understanding SQL Server Security Function HAS_Permis_BY_Name and Its USE Cases appeared first on {coding}Sight.

]]> Understanding SQL Server Lockdown to Secure Database Environment https://codingsight.com/understanding-sql-server-lockdown-to-secure-database-environment/ Fri, 13 Aug 2021 08:27:58 +0000 http://codingsight.com/?p=16088 Security is the main concern these days in every sector. Database Security is also a major worry for any customer. SQL Server is designed to secure all your data stored in the databases but sometimes we fail to apply the right set of configurations and leave a hole in our system. Hackers and unauthorized aliens …

The post Understanding SQL Server Lockdown to Secure Database Environment appeared first on {coding}Sight.

]]> Connecting a Bastion Server to a PostgreSQL Server via SSH Tunnel https://codingsight.com/connecting-a-bastion-server-to-a-postgresql-server-via-secure-shell-tunnel/ Wed, 09 Jun 2021 07:38:46 +0000 http://codingsight.com/?p=14505 PostgreSQL is a well-known relational database management system that boasts a secure environment for developers and users. But as remote work continues to be a part of every business’s new normal, IT professionals face a new set of challenges when it comes to managing the security and accessibility of their servers. Using a bastion server …

The post Connecting a Bastion Server to a PostgreSQL Server via SSH Tunnel appeared first on {coding}Sight.

]]> How to Protect MySQL Databases from Ransomware Campaigns https://codingsight.com/how-to-protect-mysql-databases-from-ransomware-attacks/ https://codingsight.com/how-to-protect-mysql-databases-from-ransomware-attacks/#comments Tue, 08 Jun 2021 08:04:16 +0000 http://codingsight.com/?p=14501 MySQL is known for being easy to use and highly secure. That’s why it is the number one choice for many organizations, including the biggest brands like Facebook, Google, Uber, and YouTube. Because it’s open-source, it’s free to use and modify even for commercial purposes. But although it can be very secure, the security features …

The post How to Protect MySQL Databases from Ransomware Campaigns appeared first on {coding}Sight.

]]> https://codingsight.com/how-to-protect-mysql-databases-from-ransomware-attacks/feed/ 1 How to Connect to Azure SQL Database Securely https://codingsight.com/how-to-connect-to-azure-sql-database-securely/ Tue, 11 May 2021 11:15:25 +0000 http://codingsight.com/?p=13476 As a database administrator, I started my journey in deploying managed SQL databases on the cloud, and I highly recommend deploying Azure SQL. Azure SQL belongs to the family of managed resources on the Azure cloud platform that runs the very familiar SQL Server engine. For most of these database resources, the Microsoft Azure platform …

The post How to Connect to Azure SQL Database Securely appeared first on {coding}Sight.

]]> SQL Vulnerability Assessment https://codingsight.com/sql-vulnerability-assessment/ Wed, 15 May 2019 23:40:20 +0000 https://codingsight.com/?p=6992 SQL Vulnerability Assessment is a feature available in the latest versions of SQL Server Management Studio (SSMS). This feature is very easy to use and it will show you all the security vulnerabilities and deviations in your SQL database. This is something you can run on your most critical databases to ensure you’re properly following …

The post SQL Vulnerability Assessment appeared first on {coding}Sight.

]]> In-depth Exploration of Row Level Security https://codingsight.com/in-depth-exploration-of-row-level-security/ Tue, 12 Feb 2019 15:59:31 +0000 https://codingsight.com/?p=6243 Introduction Organizations are becoming more and more concerned about how to reduce the cost of licensing database solutions using consolidation. Some consolidation can be achieved in SQL Server simply by taking advantage of the existing one-to-many relationship between instances and databases. However, there are cases where the solution demands that data is consolidated into one …

The post In-depth Exploration of Row Level Security appeared first on {coding}Sight.

]]> Introduction to Row-Level Security in SQL Server https://codingsight.com/introduction-to-row-level-security-in-sql-server/ Fri, 01 Feb 2019 09:56:02 +0000 https://codingsight.com/?p=6177 Why Row Level Security Matters? Prior to SQL Server 2016, table-level security was the default lowest level of security for a database. In other words, a user could be restricted to access a table as a whole. However, in some cases we need users to have access to a table, but not to specific rows …

The post Introduction to Row-Level Security in SQL Server appeared first on {coding}Sight.

]]> Oracle Database Security: Database Auditing https://codingsight.com/oracle-database-security-database-auditing/ Tue, 10 Apr 2018 16:19:53 +0000 http://codingsight.com/?p=3800 In this article, I will continue with Oracle Database Security and I will present some important facts about standard database auditing, audit triggers, and audit policies in Oracle. Database auditing has two components: monitoring and persistent registration of established database activity sets and events. The purposes of database auditing are non-repudiation, investigation of suspicious activities, …

The post Oracle Database Security: Database Auditing appeared first on {coding}Sight.

]]> Database Security in Oracle https://codingsight.com/database-security-oracle/ Tue, 27 Mar 2018 13:32:45 +0000 http://codingsight.com/?p=3195 There is no secret that information makes the world go around currently. If an enterprise takes care of its intellectual property and each employee can easily get the necessary information, the enterprise can hope for the growth. If there is chaos in data, the enterprise will fail despite the team spirit. In this article, we …

The post Database Security in Oracle appeared first on {coding}Sight.

]]>