sqlServer権限設定

drop role ProgramerRole

         
--     
create role ProgramerRole 
 
--             
grant create procedure,create view to ProgramerRole 
 
--execute        ，alter    、         ， 
--       ，      ,              
grant update,delete,select,insert,execute,alter on schema::dbo to ProgramerRole 
 
--                  (081205) 
grant showplan to ProgramerRole 
 
--       
create login username with password='123456' 
--        
create user username for login username 
 
--   TestUser   TestRole    
exec  sp_addrolemember 'ProgramerRole','username'