Cannot grant CREATEIN privilege as dbadmin?
Robert Krüger <[email protected]> Thu, 07 Jun 2007 19:33:33 +0200
| Newsgroups | gmane.comp.db.maxdb |
|---|---|
| Message-ID | <[email protected]> |
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]