The Seventh of the Ten Commandment says:
"Thou shalt be family friendly and suitable for public presentation. Thou shalt not include profanity, nudity, obscenity, pornography, depictions of drugs, alcohol, tobacco, or any harmful or illegal activity, or any material that is offensive, fraudulent, defamatory, libelous, disparaging, sexually explicit, threatening, hateful, or any other inappropriate content. The content of the fan production cannot violate any individual’s right of privacy."
For the most part I think that this is the most reasonable of CBS’s Ten Commandments. I don’t particularly want swearing and sexually explicit stuff if fan films either, not that I recall this ever happening, except in parodies. In regards to the alcohol (Scotty is going to be pissed about this – quite literally), it’s very easy to get over this issue in fan films. Just make sure you refer to it as Synthehol! But it’s a shame for any fan film that might want to explore issues of drug and alcohol misuse.
It will be interesting to see if the new Star Trek series also conforms to CBS’s own high standards in this regards. Directors are already commenting that one of the advantages of having Star Trek on a streaming service, and not on TV, is that they can push the boundaries.