示例4.sql

来自「SQL基础教程上的一些源码」· SQL 代码 · 共 14 行

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