Are you returning a cursor? Using your USERA USERB example:
DBA> create user USERA password password resource
DBA> create user USERB password password resource
DBA> COMMIT
USERA> create table foo (foobar int)
USERA> (does some insert statements)
USERA> COMMIT
USERA> grant all on foo to USERB
USERB> CREATE DBPROC userb.my_proc RETURNS CURSOR AS $CURSOR = 'some_cursor'; DECLARE :$CURSOR CURSOR for SELECT * from usera.foo;
USERB> COMMIT
USERB> CALL my_proc
Cheers, JLS
Filip Sergeys wrote:
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
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
