auditing
-
Auditing Production Catalog Privileges Through INFORMATION_SCHEMA
POST_START Auditing Production Catalog Privileges Through INFORMATION_SCHEMA I recently needed to audit the privileges assigned to the production catalog in our Databricks environment. This was part of a routine security review to ensure that only authorized users had access to sensitive data. I decided to use the INFORMATION_SCHEMA to get a clear and structured view…
A1, auditing, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, education, information, Lakehouse, paragraph ordering, paragraph structure, paragraphorder, privileges, production, profession:cloud engineer, profession:data analyst, profession:data engineer, profession:data scientist, profession:database administrator, profession:software engineer, profession:solution architect, progressive learning, schema, sql, through, unity catalog -
Auditing Production Table Privileges Through INFORMATION_SCHEMA
POST_START Auditing Production Table Privileges Through INFORMATION_SCHEMA Today, I needed to audit the privileges assigned to a specific table in the production environment. The table in question was orders from the sales schema. My goal was to understand who has access to this table and what kind of privileges they hold. I decided to use…
A1, auditing, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, education, information, Lakehouse, paragraph ordering, paragraph structure, paragraphorder, privileges, production, profession:cloud engineer, profession:data analyst, profession:data engineer, profession:data scientist, profession:database administrator, profession:software engineer, profession:solution architect, progressive learning, schema, sql, table, through, unity catalog -
Auditing Production Schema Privileges Through INFORMATION_SCHEMA
POST_START Auditing Production Schema Privileges Through INFORMATION_SCHEMA I recently needed to audit the privileges assigned to the sales schema in the production catalog. This is a common task when ensuring that only authorized users have access to sensitive or critical data. I decided to use the INFORMATION_SCHEMA to get a clear and structured view of…
A1, auditing, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, education, information, Lakehouse, paragraph ordering, paragraph structure, paragraphorder, privileges, production, profession:cloud engineer, profession:data analyst, profession:data engineer, profession:data scientist, profession:database administrator, profession:software engineer, profession:solution architect, progressive learning, schema, sql, through, unity catalog -
Auditing Security Function Ownership Used by Row Filters
POST_START Auditing Security Function Ownership Used by Row Filters I recently had to audit the security ownership of a row filter function used in our production environment. The function, production.security.region_filter, is used to enforce regional access controls across multiple datasets. My goal was to understand who owns the function and what permissions are granted on…
A1, auditing, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, education, filters, function, Lakehouse, ownership, paragraph ordering, paragraph structure, paragraphorder, profession:cloud engineer, profession:data analyst, profession:data engineer, profession:data scientist, profession:database administrator, profession:software engineer, profession:solution architect, progressive learning, row, security, sql, unity catalog, Used -
Auditing Security Function Ownership Used by Column Masks
POST_START Auditing Security Function Ownership Used by Column Masks I recently had to audit the security function ownership used by column masks in our Databricks Unity Catalog environment. The goal was to ensure that the functions used for data masking were properly secured and that only authorized users had access to them. I started by…
A1, auditing, category:business, category:education, category:software, category:technology, coding, column, data engineering, data governance, databricks, education, function, Lakehouse, masks, ownership, paragraph ordering, paragraph structure, paragraphorder, profession:cloud engineer, profession:data analyst, profession:data engineer, profession:data scientist, profession:database administrator, profession:software engineer, profession:solution architect, progressive learning, security, sql, unity catalog, Used -
Auditing Emergency Production Access After an Incident
POST_START Auditing Emergency Production Access After an Incident Yesterday, we experienced a minor security incident involving access to the production catalog. A user with temporary emergency access was found to have interacted with critical data in the production environment. Now, I’m tasked with auditing who has access to the production catalog and how it’s being…
A1, Access, after, auditing, category:business, category:education, category:software, category:technology, coding, data engineering, data governance, databricks, education, emergency, incident, Lakehouse, paragraph ordering, paragraph structure, paragraphorder, production, profession:cloud engineer, profession:data analyst, profession:data engineer, profession:data scientist, profession:database administrator, profession:software engineer, profession:solution architect, progressive learning, sql, unity catalog -
Auditing Role-Based Access Control Assignments with Unity Catalog INFORMATION_SCHEMA
POST_START Auditing Role-Based Access Control Assignments with Unity Catalog INFORMATION_SCHEMA I recently had the task of auditing role-based access control (RBAC) assignments within our Unity Catalog environment. The goal was to ensure that all access to sensitive data in the ‘production’ catalog was properly scoped and assigned to roles, following our organization’s security policies. Since…
A1, Access, assignments, auditing, category:business, category:education, category:software, category:technology, coding, control, data engineering, data governance, databricks, education, information, Lakehouse, paragraph ordering, paragraph structure, paragraphorder, profession:cloud engineer, profession:data analyst, profession:data engineer, profession:data scientist, profession:database administrator, profession:software engineer, profession:solution architect, progressive learning, role-based, schema, sql, unity catalog
