Alter Filter

Add filter rows to a database security filter. Filters control security for database objects. Use grant to assign filters to users and groups. Minimum permission required: Database designer.

Syntax

Notes

Examples

alter filter sample.basic.filt7 add read on '@Descendants("East")';

Adds a row to a Sample Basic filter named filt7, giving read-only access to the data for the eastern states.

Descriptions

Use alter filter in the following ways to edit a filter.

Key Phrase Explanation
alter filter ...add no_access on <member-expression> Block access to a specified member combination.
alter filter ... add read on <member-expression> Provide read-only access to a specified member combination.
alter filter ... add write on <member-expression> Provide write access to a specified member combination.
alter filter ... add meta_read on <member-expression> Restrict access to siblings and ancestors of the member expression. In case of a filtering conflict, the MetaRead filtering overrides the other filter permissions. For more information about metatdata filtering, see Metadata Filtering.

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com