[EMAIL PROTECTED] wrote: > > 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 ?
Two questions: - you do not want to use these roles as default-roles for this user? - which kind of application do you use, ODBC? Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
