Create Login u_TesT with Password = 'Test2012' must_change,
                            check_policy = on, 
                            Check_Expiration  = on;
go

use Test
go

Create User u_DB_TesT for login u_test 
go


--赋予U_DB_TesT select 权限

GRANT SELECT ON OBJECT::dbo.A TO U_DB_TesT ;
GO

GRANT INSERT ON OBJECT::dbo.A TO U_DB_TesT ;
GO

GRANT UPDATE ON OBJECT::dbo.A TO U_DB_TesT ;
GO