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

Enumerate about the high-level transitions result, Show, with the help of a... Show, with the help of an example, that relatively high-level transitions result when system or program is stimulated by the outside events. In diagram below, we can observe i

What does data dictionary is a special file contains, What does data dictio... What does data dictionary is a special file contains ? The data dictionary is a special file contain The name of all fields in all files.The width of all fields in all files an

Normalization, Normalize the given relation to 3NF, justifying each step Normalize the given relation to 3NF, justifying each step

Create an er diagram completely with attributes, A database is to be constr... A database is to be constructed to remain track of the teams and games of a sport league. A team has a number of players, not all of whom participate in every game. It is desired

Which types of data supported by mysql, Which types of data supported by My... Which types of data supported by MySQL for Time and Date formats?  MySQL supports a number of time and date column formats: Some of them are 1) DATE 2) DATETIME 3) TIM

What is meant by heuristic optimisation, What is meant by heuristic optimis... What is meant by heuristic optimisation?Discuss the major heuristics that are applied during query optimisation.

Explain five duties of database administrator, Explain five duties of Datab... Explain five duties of Database Administrator? 1. DBA administers the three stages of the database and, in consultation along with the whole user community, sets up an defin

What is rdbms terminology for a row, What is RDBMS terminology for a row? ... What is RDBMS terminology for a row? A tuple is a RDBMS terminology for a row

Entity Relational Diagram, What is an ERD? What is an ERD?

What are the two types of serializability, What are the two types of serial... What are the two types of serializability? The two types of serializability is a)      Conflict serializability b)      View serializability