Hi,

MAXL> grant filter X.X.Read to 'ABC';
ERROR - 1242021 - (1) Syntax error near ['Read'].

This is the error i get when I execute this command.

The filter "Read" does exist in the database and the group ABC also exists. Any ideas what can be the cause of the error? I executed a similar command for another filter of another database to be granted access to another group and that worked fine.

Not 100% sure this is your problem, but 'read' is a reserved word in MaxL. So it might work if you enclose 'read' in quotes. Although I don't think I'd choose 'read' as the name of a filter anyway.

Yeah, exactly what I thought. Maybe the problem is with Read....

READ is set in the filter not in the Grant.

Create or Replace Filter APPLICATION.DATABASE.'FILTERNAME' READ on '@IDESCENDANTS("MEMBERNAME")';

The grant statement looks like the following:

Grant Filter APPLICATION.DATABASE.'FILTERNAME' TO 'GROUPNAME';

The filter name is "Read". This filter already exists in the database. If such a naming convention were not possible, then how did the filter get created in the first place?

Hi Archie - so have you tried (note single quotes)...

grant filter X.X.'Read' to 'ABC';

Not the question you asked, but I would avoid using a reserved word as an object name whether you can make it work or not. Especially picking the name of a system-defined security role as the name of a filter.

Hi TimG,

I did try out your suggestion and it works :)

This filter name already exists though I have no idea how it worked the first time!


Thanks a lot!
Archie