Simple and Complex Views in SQL:- Grant & Revoke Using grant & revoke we can restrict user operations. Views Using views we can restrict data [particular column] A view is based on one table is called “simple views”. Syntax :- Create view
[
] as select statement [where
] Example :- Select user_name –> Dbo Example of simple [...]