Hi, i have created a mysql database. I have included some stored procedures. I have also created privileges and grants for the user and all tables, columns, rows etc. The table where i store the privileges for the stored procedures is procs_priv. I have granted all privileges to the user on the localhost.
however, when i connect to the mysql database on the localhost dreamweaver finds all of the tables and their columns in the database section but under the section 'stored procedures' it says none, even though we have a stored procedure in the database, have set up the procedure privileges in the procs_priv table for the user and the stored procedure i am lost, has anyone experienced anything like this before? or be able to provide any suggesstions or advice. thanks ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2587 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
