摘要： --预定义授权（为用户设置角色）sp_addrolemember 'db_datareader',lizhchsp_addrolemember 'db_datawriter',lizhchsp_droprolemember 'db_datareader',lizhch--语句（对整体表的操作）grant create table to lizhch--对象（对单个表的操作）grant select on tt to lizhchgrant insert on tt to lizhchgrant update on tt to lizhchgran 阅读全文