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?
