Crystal Dictionary and secure MSSQL database

[noonie]

I am currently trying to get some key people in my company using Crystal Reports. I have a security issue with some of them. I need to restrict table access to these people and I am trying to do it with Crystal Dictionary. It works all fine and dandy except for once the dictionary is opened and then closed, you can still use the data explorer to gain direct access to the "secure" server because the ODBC connection remains open. Is there any way to slove this within Crystal???

I don't want to set up table level permissions in SQL Server if I don't have to. (The data server is normally accessed thru an ERP app server which handles all the security issues.)