Setting SQL Server Users for Crystal Reports
Posted on 2011-03-10
Hello, I want to grant access to a user to our database using SQL Server Management Studio (SQL Server 2005) in order that they can run Crystal Reports. We only have sa and another user for our main ERP system that it uses.
How do I go about setting up another user so they can connect using Crystal Reports and have only Select (read-only) access? What are the steps?
I'm not a SQL Server expert!