Assign DataRole

Use this command to specify the database privileges of a DataRole established by CREATE DATAROLE

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

where:

• RoleName is the name of a symbol access role.
• DimName is the dimension to which the DataRole is to be given access.
• RESTRICTED means that access is defined as a subset of the dimension spanning more than one level.
• SymName is the top symbol in the hierarchy to which you want to give the role access.
• AccessType is a setting that determines whether the role’s users have read/write access. Select one of the following:

  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.
• FIXED means that access is constrained to a single symbol in the dimension.
• Priority is a numeric value between 0 and 99 (0 representing the lowest priority) representing the position of the symbol with respect to its parent.
• FULL enables write access to all symbols in the dimension.

Creating an ASCII input file

To assign 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] [{Priority]
RoleName{ACCESS{DimName{FIXED{SymName{AccessType[{Priority]
RoleName{ACCESS{DimName{FULL[{Priority]

ASSIGN 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"

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

MAINTENANCE ON
ASSIGN DATAROLE @datarole.txt
MAINTENANCE OFF                                    

See also

• Create DataRole