DATA CONTROL LANGUAGE (D.C.L) DBMS LAB MANUAL FOR M.E/M.TECH STUDENTS - Code

Latest

programs

Wednesday, October 12, 2011

DATA CONTROL LANGUAGE (D.C.L) DBMS LAB MANUAL FOR M.E/M.TECH STUDENTS


DATA CONTROL LANGUAGE (D.C.L)
DCL provides uses with privilege commands the owner of database objects (tables), has the soul authority ollas them. The owner (data base administrators) can allow other data base uses to access the objects as per their requirement

1. GRANT: The GRANT command allows granting various privileges to other users and allowing them to perform operations with in their privileges
For Example, if a uses is granted as ‘SELECT’ privilege then he/she can only view data but cannot perform any other DML operations on the data base object GRANTED privileges can also be withdrawn by the DBA at any time

Syntax:            SQL>GRANT PRIVILEGES on object_name To user_name;
Example:         SQL>GRANT SELECT, UPDATE on emp To hemanth;

2. REVOKE: To with draw the privileges that has been GRANTED to a uses, we use the REVOKE command

Syntax:            SQL>REVOKE PRIVILEGES ON object-name FROM user_name;
Example:         SQL>REVOKE SELECT, UPDATE ON emp FROM ravi;

No comments:

Post a Comment