例：授予zhang1在数据库tele114上建表，建视图，建存储过程;对表students有select,reference权；对name,native字段有update权。  
1> use tele114  
2> go  
3> grant creat table,create procedure ,create view to zhang1  
4> go  
5> grant select,reference on students to zhang1 with grant option  6> go  
7> grant update on students(name,native) to zhang1  
8> go  
9> sp_helprotect  
10> go