This table lists the permissions that you can assign to users, and whether they are inherited through group membership.
Permission  | 
Inherited through group membership  | 
|---|---|
ALL  | 
Yes  | 
ALTER  | 
Yes  | 
CONNECT  | 
No  | 
DELETE  | 
Yes  | 
INSERT  | 
Yes  | 
INTEGRATED LOGIN  | 
No  | 
KERBEROS LOGIN  | 
No  | 
REFERENCES  | 
Yes  | 
SELECT  | 
Yes  | 
UPDATE  | 
Yes  |