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.
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.
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 |