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

What are the advantages of relational data model, What are the advantages o... What are the advantages of relational data model? Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer

Basics of relational models, In the first unit of this block, you have been... In the first unit of this block, you have been given with the details of the Database Management System, its structure, advantages etc. This unit is an attempt to give you informat

How to control as concurrent tasks, Control as Concurrent Tasks The ex... Control as Concurrent Tasks The expression control as simultaneous task means applying control for those events of object which can happen simultaneously. An object can be imp

What are temporary tables, What are temporary tables? Temporary tables... What are temporary tables? Temporary tables exist solely for a particular session or whose data persists for the duration of the transaction.

What are referential integrity constraints, What are referential integrity ... What are referential integrity constraints? A value that appears in single relation for a given set of attributes also appears for a particular set of attributes in another rel

What is the full form of odbc, What is the full form of ODBC ? ODBC stand... What is the full form of ODBC ? ODBC stands for Open Database Connectivity.

Naïve bayesian approach-id3 algorithm, You are working for the ABC Telecom ... You are working for the ABC Telecom and are given some customer records for data mining. You are asked to discover, from the data, patterns that characterize low-, medium- and high

Describe queries with complex types, Describe queries with complex types? ... Describe queries with complex types? The present extension of the SQL query language deal with the complex type Let us start with the simple example: Find the title and t

Data fregmentation, why we fregment at all? why we fregment at all?

Optimistic concurrency contents -write-set(t), write-set(T): Each data ite... write-set(T): Each data items that are written by a transaction T