----------------------------------------------------------- New Message on MumbaiUserGroup
----------------------------------------------------------- From: GiddyRavi007 Message 1 in Discussion Hi, In our application, we are using VB 6.0, SQL Server 2000 and Crystal Reports 10 as a development tool. We have a set of SQL Server Authenticated Users which are created on the SQL Server side. For Security reasons we are not giving any Grant Permission (Select, Insert, Update, Delete, Execute) on any of the Database Objects to these users. We have created a Application Role on SQL Server level which has all the permission for all the database objects. When the user logs into the our VB application, the connection is created with the ADO Connection Object to access the server database. Once the session is created with the database, the Application Role is activated on that ADO connection object. Once the Application Role is activated, user access will be over written with Application Role access rights and the connected user implicitly gets the access to all the database objects. Integration of "ApplicationRole" with VB works fine. Our VB application uses the CrystalActiveXReportViewer object for calling of the Crystal Reports. These report names and path is picked up from the database and dynamically called at runtime by using ' LogOnServer Method of CRAXDDRT.Application object. In this we are passing ServerName, Databasename, User name and Password. With this information, user is able to connect to the server but as he does not have required access on the database objects, so he is not able to run the report. Now the problem what we are facing is, we are not able to pass the connection from VB application to the Crystal Report which has the Application Role active. Neither we are able to activate the application Role on the Crystal Report side. So to execute the crystal report we are not getting the required access to the database objects and it fails. Request you to please suggest some solution by which we can implement the Application Role in case of Crystal Report 10. Thanks in Advance. Ravi Katira ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/MumbaiUserGroup/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
