Depends what you mean by “work”. Being a cop is not a protected class so yeah you can expel one from your private business for any reason or no reason at all.

But if they are investigating a crime, executing a warrant, or any other kind of official business then no this sign doesn’t do shit legally. This place looks like it serves alcohol and is open to the public so there’s no right to privacy from police when holding a liquor license.