示例4.sql

SQL基础教程上的一些源码

GRANT SELECT(City) 
ON student_full_view
TO Bruce

SELECT Name,Numb,City
FROM student_full_view

REVOKE SELECT(City) 
ON student_full_view
TO Bruce

DENY UPDATE
ON student_full_view
TO Bruce