Restrict access to specific user group

[Gill1978]

Hi,

I need to restrict a user group (WORLD\LONIB SQLD-CWA-RO) from a specific sql server table Audit_Auditors:

I've tried going into the permissions on the table and unclicking the public access and clicking on SELECT/ UPDATE/ DELETE for all roles except the above but that hasn't worked ...

Can anyone help ?

Thanks

Julie

 

[Gill1978]

Hi ...

This seems to have worked :

revoke select on dbo.Audit_Auditors to [LONIB SQLD-CWA-RO];
revoke INSERT on dbo.Audit_Auditors to [LONIB SQLD-CWA-RO];
revoke UPDATE on dbo.Audit_Auditors to [LONIB SQLD-CWA-RO];
revoke DELETE on dbo.Audit_Auditors to [LONIB SQLD-CWA-RO];

 

[yelworcm]

You will probably want to look into the DENY command, if you want to forbid them absolutely. If one of these users gets added to the db_datareader group, they will have access to read the table again.

 

[icemel]

Yes, as yelworcm says, SQL Server recommends using DENY to a user group, that way the entire group cannot access an object, eases administration