Table 8-2 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 |