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:krueger@stripped]
>> Sent: Donnerstag, 7. Juni 2007 19:34
>> To: maxdb@stripped
>> 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/maxdb?unsub=1
>>
>>
>>
>
> ______________________________________________________________________
> This email has been scanned by the MessageLabs Email Security System.
> For more information please visit http://www.messagelabs.com/email
> ______________________________________________________________________
