About this question
In which situation can I use MAC (mandatory access control) in a refined way rather than DAC (discretionary access control) or RBAC (role based access control)?
In which situation can I use MAC (mandatory access control) in a refined way rather than DAC (discretionary access control) or RBAC (role based access control)?
Log in to share your answer and help other learners.
Log in to answerBest Answer · By JanBask MS SQL Server Expert
Answered on Aug 3, 2023
Every system is utilized for various overriding security necessities. The three prime security necessities include confidentiality, integrity, and availability.
MAC assists the security necessity of confidentiality. DAC assists the necessity of availability. RBAC assists the necessity of integrity. MAC frames decisions grounded on labeling and then authorities. DAC frames decisions only based on permissions and RBAC frames decisions based on roles. When the system frames decisions, it will push the security necessities. While utilizing the wrong system, you can kludge it to do what you wish. DAC and RBAC are the suitable examples of active directory roles. RBAC inclines toward databases. This is a great example where no other system can be used since RBAC is meant for customer service and billing. MAC inclines towards the military system or high security necessary implementations. A major element that is seen in MAC is a construct of dominance. When there is secret level clearance, you can’t get permission to view a Top secret document. A great use of MAC would be on the web server where a custom policy needs to be written that defines the Core processes which can be processed by the system account.
The SQL Server Online Trainingat JanBask Training offers experience like offline classes, saving students from the hassle of traveling to the physical location. The training provides a total SQL Server discipline preparation by teaching the core concept and techniques that the job role demands. The training also gives extensive training to impart fundamental and advanced concepts through interesting e-tools and expert-led SQL Server classes. Furthermore, JanBask Training helps you get job-ready and face the tough competitive market with confidence.
Free tutorials and interview questions from industry experts — learn the skill, then get ready to prove it.
Step-by-step SQL Server guides from industry experts
Common SQL Server interview questions, answered
Guides, tips and career advice on SQL Server from JanBask experts.
SQL Server Top 75 SSAS Interview Questions and Answers For Beginners & Experts
Prepare for your SSAS interview with our comprehensive guide featuring 75 top SQL Server Analysis Services interview questions…
SQL Server How to Become a SQL Database Administrator?
How to become a sql database administrator In 2025, discover what these professionals do, explore how much they earn and learn…
SQL Server OLAP vs OLTP: Key Differences, Architectures, Performance & Real-World Examples
Compare OLTP vs OLAP with clear definitions, architecture diagrams, real-world examples, and FAQs. Learn when to use each system…
SQL Server 70+ Most Asked SSIS Interview Questions for Freshers & Experienced
Prepare for your next SQL Server Integration Services (SSIS) interview with our top 70+ SSIS interview questions and answers.…