International Journal For Multidisciplinary Research

E-ISSN: 2582-2160   •   Impact Factor: 9.24

A Widely Indexed Open Access Peer Reviewed Multidisciplinary Bi-monthly Scholarly International Journal

Call for Paper Volume 8, Issue 2 (March-April 2026) Submit your research before last 3 days of April to publish your research paper in the issue of March-April.
Submit Research Paper Join as a Reviewer

Plagiarism is checked by the leading plagiarism checker TurnItIn

Call for Paper

Volume 8 Issue 2
March-April 2026

Submit your research paper

Indexing Partners
Academia Advanced Sciences Index Bielefeld Academic Search Engine CiteSeer DRJI Google Scholar Independent Search Engine & Directory Network ISI (International Scientific Indexing) Issuu Mendeley Research Networks
RefSeek ResearcherId - Thomson Reuters ResearchGate Scirus Scribd Semantic Scholar UTeM - Universiti Teknikal Malaysia Melaka Wiki for Call for Papers WorldCat Zenodo

Secure Data Access Framework Using Dynamic Data Masking and Auditing in Azure SQL for Regulatory Compliance

Author(s) Ramadevi Nunna
Country United States
Abstract Background:
The rapid adoption of cloud-based databases, organizations face increasing challenges in protecting sensitive data while complying with regulatory standards. Azure SQL provides built-in security features, yet improper configuration may lead to data exposure. Ensuring secure access without compromising usability remains a critical concern. Regulatory bodies demand strict control, visibility, and accountability over data usage. Hence, a structured security framework is essential. This study addresses these emerging security and compliance needs.
Aim:
The primary aim of this work is to design a secure data access framework using Dynamic Data Masking (DDM) and auditing features in Azure SQL. The framework focuses on minimizing unauthorized data exposure. It aims to support regulatory compliance such as GDPR and HIPAA. The goal is to balance data security with operational efficiency. Additionally, the framework enhances transparency in data access. It provides organizations with a compliance-ready architecture.
Method:
The proposed framework integrates role-based access control, Dynamic Data Masking, and Azure SQL auditing. Sensitive attributes are masked dynamically based on user roles. Auditing logs are enabled to track database activities in real time. The system architecture is implemented using native Azure SQL features. Controlled experiments are conducted to evaluate access behavior. Compliance alignment is validated through policy mapping.
Results:
The results show a significant reduction in unauthorized data visibility. Masked users could only view obfuscated data, while privileged users retained full access. Audit logs successfully captured all access attempts and query executions. Performance overhead introduced by masking and auditing remained minimal. The framework improved compliance traceability. Overall system security posture was strengthened.
Conclusion:
This study demonstrates that combining Dynamic Data Masking with auditing provides an effective security solution for Azure SQL. The framework ensures regulatory compliance without degrading database performance. It offers scalable and flexible security controls. Organizations can adopt this approach to enhance data governance. Future enhancements may include automation and AI-based threat detection. The framework serves as a practical reference for secure cloud data access.
Keywords Azure SQL, Dynamic Data Masking, Data Security, Auditing, Regulatory Compliance.
Field Engineering
Published In Volume 8, Issue 1, January-February 2026
Published On 2026-02-26
DOI https://doi.org/10.36948/ijfmr.2026.v08i01.69949
View / Download PDF File

Share this



E-ISSN 2582-2160
CrossRef

CrossRef DOI is assigned to each research paper published in our journal.

IJFMR DOI prefix is
10.36948/ijfmr

Downloads
Research Paper Format Copyright Permission Form and Undertaking Form Cover Page Vol 8 Isu 2Cover Page Vol 8 Isu 1Cover Page Vol 7 Isu 6

All research papers published on this website are licensed under Creative Commons Attribution-ShareAlike 4.0 International License, and all rights belong to their respective authors/researchers.

CC-BY-SA Open Access

About IJFMR
Fees & Payment
Current Issue
Publication Archive 		Submit Research Paper
Track Submission Status
Publication Guidelines
Publication Ethics
Peer Review & Plagiarism 		Join as a Reviewer
Editors & Reviewers
Reviewer Referral Program
Get Reviewer Membership Certi. 		Website/Journal Policies
Usage Policy
Content Policies
Privacy Policy
Contact Us +91-9687-828-838 editor@ijfmr.com
Powered by Sky Research Publication and Journals