SQL 2005创建只读帐号

CREATE LOGIN sa_ro WITH PASSWORD = '123456', CHECK_POLICY=OFF,default_database=shaj_synadmin;

go

create user sa_ro for login sa_ro

grant select on sa_affair_info to sa_ro

grant select on sa_document_info to sa_ro

--grant execute to sa_ro 

--将表的字段的更新权限给用户

--grant update on testdb(A1,A2) to sa_ro;

--当然您想回收这个更新权限的话可以用

--revoke update on testdb(A1,A2) to sa_ro;

--删除用户

drop user sa_ro

go

--删除登陆名

drop login sa_ro

go