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]