Hi, i have defined different roles for the users of my db-System. When one user makes a connect to the Database, he has very low rights. (Select-Rights to make Odbc-Selections in Excel ...)
My application first calls the statement set role my_role identified by my_role_password to get more rights for the user in the application-Context. The set role-Statement is called directly after the connect-Statement. If the user is inactive for a long time he will be automatically disconnected from the Database (Session-Timout) e.g. 5 Minutes. With the next Db-Statement the user will be automatically reconnected to the Database. This is transparent for my application. The problem now is, after this reconnect the user falls in his default role, this means he has not the needed rights to work in the application. My question is: is there a way to inform the application, that a reconnect has been done, so that the "set-role-statement" can be called again ? i would be glad to get help on this Topic. regards Matthias Lak�mper ______________________________________________________________________________ Seien Sie dabei und sichern Sie sich 100% Leistung, 100% Pr�mie und 100% Zufriedenheit. Jetzt unter http://club.web.de/?mc=021105 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
