Greetings all, Our DBAs have our SQL Server databases configured so we connect with a user that has not privileges then we must switch to application role using sp_setapprole stored procedure. How can I get this to work with a datasource? I can connect with the user name but getting the sp_setapprole executed is proving more of an issue.
I have thought about using it in the SQL that is called when a connection is created but the whole reason for using app roles is so no one knows they are being used. Make any sense? Any and all help is appreciated. Earnie! View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3889761#3889761 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3889761 ------------------------------------------------------- SF.Net email is Sponsored by the Better Software Conference & EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
