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]