Introducing StealthAUDIT 11.5! Complete your cloud security puzzle. LEARN MORE
Stealthbits

INSIDER THREAT SECURITY BLOG

And other things that keep you up at night

Blog >Databases

Browsed By
Category: Databases

Installing SQL Server 2019 on Centos 8

Installing SQL Server 2019 on Centos 8

| Sujith Kumar | | Leave a Comment
Microsoft announced the release of SQL Server 2019 at Ignite 2019 with some exciting new features including Scalar UDF inlining, always-on connection, and Linux support. In my previous blog, I walked through the steps of integrating a Linux host running on CentOS 8 into a Windows Active Directory (AD) domain configured on Windows 2012 R2 Server Standard Edition. In this blog, I will be using the same AD domain joined CentOS 8 server to install and configure SQL Server 2019 for Linux. Wheth…
Understanding Effective Access in SQL Server

Understanding Effective Access in SQL Server

| Sujith Kumar | | Leave a Comment
Microsoft SQL Server is the third most popular Relational Database Management System (RDBMS) as of September 2020 according to DB-Engines ranking.  It is also the most confusing RDBMS when it comes to database security compared to other popular RDBMS systems, such as Oracle, PostgreSQL, etc.  Having worked with Oracle for a very long time, I found SQL Server security very confusing when I started working with it for the first time.  Part of the complication stems from the fact …

Public Role in SQL Server

| Sujith Kumar | | Leave a Comment
Roles in relational databases make it easier to grant and revoke privileges from multiple users at once.  Multiple users can be grouped into one or more roles in a database. Rather than revoking or granting a privilege to a user or a group of users, the privilege can be granted or revoked from the ROLE.  In my previous blog, I talked about the PUBLIC role in Oracle.  In this blog, I will try to explain what the public role means in Microsoft SQL Server and some of the…

Public Roles in Oracle

| Sujith Kumar | | Leave a Comment
Roles in relational databases make it easier to grant and revoke privileges from multiple users at once.  Multiple users can be grouped into one or more roles in a database. Rather than revoking or granting a privilege to a user or a group of users, the privilege can be granted or revoked from the ROLE.  While users can create their own roles and assign one or more privileges to the roles, most databases come with a pre-defined role called PUBLIC. In this blog, I will try to expl…

Subscribe

DON’T MISS A POST. SUBSCRIBE TO THE BLOG!


Loading

© 2022 Stealthbits Technologies, Inc.

Start a Free Stealthbits Trial!

No risk. No obligation.

FREE TRIAL