DCL-Grant

nTo grant the permissions for the user to access data

Syntax:

GRANT SELECT,UPDATE on Table To userid

GRANT ALL ON Table To userid

Query:

GRANT SELECT,UPDATE on EMPtbl1 To Raviteja

GRANT ALL ON Table To Raviteja