Remove DataRole

Use this command to remove the database privileges of a DataRole created by a CREATE DATAROLE command.

You can use the following role types in the Remove DatatRole command:

• RESTRICTED—defines access as a subset of the dimension spanning more than one level.
• FIXED—defines access to a single symbol in the dimension.
• FULL—enables write access to all symbols in the dimension.

The parameters to include vary depending on the specified role type.

REMOVE DATAROLE RoleName ACCESS DimName RESTRICTED SymName [AccessType NumLevels Priority]
REMOVE DATAROLE RoleName ACCESS DimName FIXED SymName
REMOVE DATAROLE RoleName ACCESS DimName FULL 

where:

• RoleName is the name of a symbol access role.
• DimName is the dimension containing to which the DataRole is to be given access.
• SymName is the top symbol in the hierarchy from which you want to remove the role access.
• AccessType is a setting that determines whether the role’s users have read/write access. This parameter is optional; however, if you specify AccessType you must also specify NumLevels and Priority.
  Select one of the following for the AccessType:

  Value	Description
  W	Write access, to allow the user to change data.
  R	Read-only access, to allow the user to read the data but not change it. This is the default.

• NumLevels is a number representing the number of hierarchy levels below SymName. This parameter is optional; however, if you specify NumLevels you must also specify AccessType and Priority.
• Priority is a number that designates the symbol’s position in the hierarchy relative to its parent. Symbols are listed in order of ascending priority, with zeros falling at the bottom of the list. This parameter is optional; however, if you specify Priority you must also specify AccessType and NumLevels.

Creating an ASCII input file

To remove a large number of DataRoles, specify the parameters for this command in an ASCII file.

Create an ASCII file containing the following information:

RoleName{ACCESS{DimName{RESTRICTED{SymName{AccessType[{NumLevels]

Syntax (with an ASCII file)

REMOVE DATAROLE @FileName

where:

• FileName is an ASCII file containing the data. It can include a complete or partial folder path in the format C:\...\FileName. If FileName includes spaces, enclose it in double quotation marks; for example:

  @"C:\My Documents\My Data.txt"

If the document is in the same location as lv_af.exe, you do not need to specify the drive or path.

REMOVE DATAROLE NorthAmAccounts