Hi, only for schemas create with CREATE SCHEMA ... you can grant this privilege. For the default-schemas, having the same name as a user and implicitly created when creating a user, this privilege can not be granted.
Please use additional schemas or schemas instead of users. Elke SAP Labs Berlin Sitz der Gesellschaft/Registered Office: Walldorf, Germany Vorstand/SAP Executive Board: Henning Kagermann (Sprecher/CEO), Shai Agassi, Léo Apotheker, Werner Brandt, Claus Heinrich, Gerhard Oswald, Peter Zencke Vorsitzender des Aufsichtsrats/Chairperson of the SAP Supervisory Board: Hasso Plattner Registergericht/Commercial Register Mannheim No HRB 350269 Diese E-Mail kann Betriebs- oder Geschäftsgeheimnisse oder sonstige vertrauliche Informationen enthalten. Sollten Sie diese E-Mail irrtümlich erhalten haben, ist Ihnen eine Kenntnisnahme des Inhalts, eine Vervielfältigung oder Weitergabe der E-Mail ausdrücklich untersagt. Bitte benachrichtigen Sie uns und vernichten Sie die empfangene E-Mail. Vielen Dank. This e-mail may contain trade secrets or privileged, undisclosed, or otherwise confidential information. If you have received this e-mail in error, you are hereby notified that any review, copying, or distribution of it is strictly prohibited. Please inform us immediately and destroy the original transmittal. Thank you for your cooperation. > -----Original Message----- > From: Robert Krüger [mailto:[EMAIL PROTECTED] > Sent: Donnerstag, 7. Juni 2007 19:34 > To: [email protected] > Subject: Cannot grant CREATEIN privilege as dbadmin? > > > 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] > > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
