I have a number of reports accessing a Microsoft SQL Server database. I have created user logins on the SQL Server and given them access to the necessary database. My report designers use these logins.....however, when they try to add a table to an already existing report they can't see all of the table in the database. The only way that I have found to get this to show all available tables in the database is to give the MSSQL login adminstrative rights to the database....obviously I don't want to do this. Does anyone know what rights someone needs on their sql server login so they can add any table from a database they have access to? Thanks,
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
MSSQL Security rights for CR 8 report
- Thread starter bashboy
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question