Problem:

(a) Given the following relation:

Stats(Name,Sex,Children, Occupation, Salary, Tax, Audits) Write SQL code to define the following security constraints:

(i) User Ford RETRIEVE privileges over the entire relation.

(ii) User Smith INSERT, DELETE privileges over the entire relation.

(iii) User Nash RETRIEVE privileges over the entire relation and UPDATE privileges over the SALARY AND TAX attributes(only).

(iv) User Todd RETRIEVE privileges over NAME, SALARY AND TAX attributes only.

(v) User Pope full privileges(RETRIEVE,UPDATE,INSERT,DELETE) over tuples for preachers only.

(b) In the context of security, demonstrate your understanding on the following terms: (support your answers with appropriate examples wherever possible).

(i) Discretionary Access Control.

(ii) Mandatory Access Control.

(iii) Audit Trail.

Posted Date: 11/13/2013 3:03:31 AM | Location : United States

Ask an Expert

Related Discussions:- Explain discretionary access control, Assignment Help, Ask Question on Explain discretionary access control, Get Answer, Expert's Help, Explain discretionary access control Discussions

Write discussion on Explain discretionary access control
Your posts are moderated

Write your message here..

Related Questions

Relationship sets, A relationship set is a set of relationships of the simi... A relationship set is a set of relationships of the similar type. For example, let consider the relationship among two entities sets course and student. Collection of all the in

Explain the togaf framework for enterprise architectures, Question: (a)... Question: (a) With the help of a diagram, explain the TOGAF framework for enterprise architectures. (b) Where would you position enterprise architectures in an enterpri

Database for Managers, I have to create a database about anything of my cho... I have to create a database about anything of my choice. It has to contain 4 queries, and 4 forms. It can be anything as simple as a shoe inventory with numbers - is this a service

Illustrate the class diagram for class room scheduling, Illustrate the clas... Illustrate the class diagram for class room scheduling system If in any college, the number of classrooms are limited which have to be allocated to various classes and instruct

Set concept is used in which type of modelling, SET concept is used in whic... SET concept is used in which type of modelling? SET concept is used in Network Model.

What are the purpose for having variable length records, What are the purpo... What are the purpose for having variable length records? What kinds of separator characters are required for each? Variable-Length Records - Variable-length records are thos

Payment processors, We have a buildup of payments that need to be processed... We have a buildup of payments that need to be processed. You will need:- To prepare customer account on our site Process payment (you must have working Paypal account to d

What is the difference between link and reference, What is the difference b... What is the difference between link and reference? The fundamental difference between links and references is that links are symmetrical on the other hand references refer only

Briefly explain the state diagram by taking one example, Briefly explain th... Briefly explain the state diagram by taking one example. State Diagram - An object can be given a sequence of input instructions. The state of the object can vary depending u

Distributed Database query processing , I am doing research in this area, e... I am doing research in this area, especially in sime join and join efficacy when several relations have been queried. Relations located in different sites. I need something like n