Thanks a lot!
Regards,
Robert
Zabach, Elke wrote:
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: maxdb@lists.mysql.com
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]
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
