Assignment - 4 Database Security

Assignment – 4     Database Security   Submission Date : 13-Apr-2011  

Q.1	Explain the Following Questions in detail.
	1.    What is database security? Explain the goal of database security? 2.    Describe the Granting & Revoking privileges using SQL with syntax and example. Explain account level, table level and column level privileges. 3.    Explain concept of audit train in detail 4.    Explain the Mandatory Access Control with Bell-Lapadulla model. 5.    What is statistics database security? 6.    What do you mean by firewall? What are firewall techniques that are used in database Security? 7.    Explain data encryption with different schemes. 8.   Using Polyalphabetic substitution method and encryption key, “SECURITY”, encrypt the plaintext message “SELL ALL STOCKS”
Q.2	Differentiate the following :
	1.    Security Vs integrity 2.    Discretionary Access Control Vs Mandatory Access Control 3.    Authorization Vs Authentication. 4.    Simple Property Vs Star Property 5.    Audit Trail Vs Transaction Log 6.    Simple Substitution Method Vs Polyalphabetic Substitution Method