Hello, The following situation confuses me
Users A and B User A: grant all privileges on all its tables to B - User B writes a select query on tables from user A -> result come back - User B embeds the same query in a dbproc -> returns no result. - User A creates the same dbproc and call's it -> results come back. - I granted execute right to user A on the dbproc from user B and make user A call the dbproc from user B -> no results. This makes me suspect that something is wrong with the privileges. But what privilege is missing? I could not find anything relevant under "grant" in the documentation. Thanx for your help, Regards, Filip Sergeys -- *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* * System Engineer, Verzekeringen NV * * www.verzekeringen.be * * Oostkaai 23 B-2170 Merksem * * 03/6416673 - 0477/340942 * *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
