Your question, your audience. Choose who sees your identity—and your question—with question security.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Absolutely. It is called SQL Server permissions. You GRANT the necessary permissions to the user to do their job and nothing else.