Asif Lodhi wrote: > Hi All, > > I want to restrict all direct access to tables and allow users access > only through the stored procedures. > > However, I haven't seen any explicit mention in the docs that one can > return a resultset/recordset from a stored routine - that's what I can > do using MS-SQL Server. If this cannot be done then the security > benefit of limiting access only to the stored routines cannot be > achieved. > > I will very much appreciate your help, comments and advice.
How are your clients connecting to MySQL? If you're writing your own apps using the C libraries, then you are in luck. If you are using MyODBC, then you will have to wait until the v5 connector is complete. If you are using DBD::mysql, then I'd be interested to hear how it works out - I'm about to start testing that in the next couple of days. I don't know the status of the JDBC or PHP drivers. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
