# data[].attributes.headline
Grant select from Employee where dno=5 on name, bdate, address to a with grant

# data[].attributes.subject
Grant select from Employee where dno=5 on name, bdate, address to a with grant

# data[].attributes.body
احمد سبيلا

# data[].attributes.body
CREATE VIEW a3view AS
SELECT NAME, DATE, ADDRESS
FROM EMPLOYEE
WHERE DNO=5;

GRANT SELECT
ON a3view
TO A3;

# data[].attributes.body
Grant select employee

# data[].attributes.body
Select name address
From employee

# data[].attributes.body
grant select name,address,beaten where dno=5

# data[].attributes.headline
عبدالله بن عائضR

# data[].attributes.body
عبدالله بن عائض
Revoke grant from A3
Creat grant to A3 admin
Format A3

# data[].attributes.body
CREATE VIEW EMPLOYEE  name, bdate, address where dno=5
From EMPLOYEE

# data[].attributes.body
Grant

# data[].attributes.body
grant select (name,data,address on employ

# data[].attributes.body
Abdulaziz jedaah
Creat view

# data[].attributes.body
Grant select Name,bdate,address on employee To A3

# data[].attributes.body
Grant select Employee

# data[].attributes.body
grant SELECT on EMPLOYEE
to A3 WITH GRANT OPTION
CREATE VIEW A3 EMPLOYEE on
SELECT NAME, BDATE, ADDRESS
FROM EMPLOYEE
WHERE DNO = 5

# data[].attributes.body
Crest view A3 empolyee As
Select Name, DATE, ADDRESS
FROM EMPLYEE
WHERE DNO=5;

Ai grant Select on the view A3 EMPLYEE to A3
Grant Slect ON A3 EMPLYEE to A3
With Grant Option;

# data[].attributes.body
Select create view (name, address, date) from  Employee where Dno = "5" , grant to A3 with grant option

# data[].attributes.body
Grant select

# data[].attributes.body
Create view private as select name, bdate, address where dno =5 from Employee ;

Grant select to private with grant;

# data[].attributes.body
CREATE VIEW EMPLOYEE (name, bdate, address where dno=5) GRANT SELECT FROM employee TO A3 WITH GRANT OPTION

# data[].attributes.body
Suppose that A1 wants to give back to A3 a limited capability to SELECT from the EMPLOYEE relation and wants to allow A3 to be able to propagate the privilege. The limitation is to retrieve only the NAME, BDATE, and ADDRESS attributes and only for the tuples with DNO=5.

# data[].attributes.body
GRANT SELECT (name, bdate, address where dno=5) ON employee TO A3 WITH GRANT OPTION