ODBC connection between Crystal Report and SQLServer 2008

  • Could anyone tell me how to set up a read only access using ODBC so that a user can only extract data from SQLServer 2008 using Crystal Report. Thank you in advance.

  • I don't think you can change the ODBC setting to read only. It is what it is, just a connection into the database.

    You should add the users to a Database Roll and grant the Roll SELECT permissions to the Table or View. They will not be able to modify the data.

    thx

    A nod is as good as a wink to a blind bat.

  • Check this one...A complete tutorial on Crystal Report....Crystal Report Tutorial

    Charles

  • Thanks for the reply but I no longer need any feedback. If you haven't noticed, I posted the question about 3 years ago.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply