Hi,
it's probably either a stupid mistake or a fundamental misunderstanding of Maxdb concepts on my part but after reading some of the maxdb documentation I expected that dbadmin can grant any privilege to any user but that does not appear to be the case.
I have three users (all resource) TEST, TEST1, TEST2 in my database and I want TEST to be able to create and drop tables etc. in schemas TEST1 and TEST2 as well. I connected as dbadmin and issued the following statement:
GRANT CREATEIN,DROPIN ON TEST1, TEST2 TO TEST and got: Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed Syntax error or access violation;-5001 POS(26) Missing privilege:TEST1 GRANT CREATEIN,DROPIN ON TEST1, TEST2 TO TEST I tried only with CREATEIN and only TEST1 but got the same result. I'm using Maxdb 7.6 on Windows. Thanks in advance for any hints, Robert -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
