James Coen wrote:
>
> I am wondering if anyone else has had this problem or if it
> is something I
> am doing.
> I created a role (as identified by password) and assigned
> permissions to
> it. Then I created a usergroup and am attempting to assign
> that role as
> the default for the usergroup, but I keep getting the following error:
> Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
> Syntax error or access violation;-3008 POS(51) Invalid
> keyword or missing
> delimiter.
> ALTER USERGROUP bscm_ug00 DEFAULT ROLE bscm_admin IDENTIFIED
> BY baanadmin
>
> I am using MAXDB 7.5.00.08 on Windows 2000 and the user that I am
> attempting to assign the role with is the owner of the DB and
> the creator
> of the role and group.
>
> Any thoughts?
>
Unfortunately yes:
documentation and implementation are not syncronized.
Do not specify IDENTIFIED BY baanadmin and things will do.
We will fix that problem.
Thank you for reporting.
Elke
SAP Labs Berlin