Click On the Download Button Below 
Introduction to Data Protection and DCL Statements :-
When multiple users can access database objects, authorization can be controlled to these objects with privileges. Every object has an owner. Privileges control if a user can modify an object owned by another user. Privileges are granted or revoked either by the instance administrator, a user with the ADMIN privilege or, for privileges to a certain object, by the owner of the object.
1)Â Â Â Â Â System Privileges:
System privileges are privileges given to users to allow them to perform certain functions that deal with managing the database and the server
e.g Create user, Create table, Drop table etc.
2)Â Â Â Â Â Object Privileges:
Object privileges are privileges given to users as rights and restrictions to change contents of database object – where database objects are things like tables, stored procedures, indexes, etc.
Ex. Select,insert,delete,update,execute,references etc
Data Control Language(DCL) is used to control privilege in Database. To perform any operation in the database, such as for creating tables, sequences or views we need privileges.
Objectives of Data Protection and DCL Statements :-
After going through this unit, you will be able to:
- Learn functions in SQL, like math string and date
- state the DCL statements in SQL
- describe the basic concepts in views, subqueries, join and system privilege
- illustrate the role of a DBA
List of References :-
- www.w3school.com
- www.tutorialspoint.com
- wielyIndia.com or
- DreamtechPress.com
- www.williamstannings.com
- Database System Concepts(4th Edition) by Korth, Tata McGraw Hill
- Introduction to Database Management Systems by ISRD Group, Tata McGraw Hill
- SQL ,PL/SQL the Programming language of Oracle by Ivan Bayross(4th edition), BPB.
- Advanced Database Management System by Dasgupta Chakrabarti, Dreamtech
- Database Systems Subject Link