GRTV – Granting Report Views to a Dimensions User

This command grants report views access to nominated users to a nominated base database, after first checking that they are not currently granted such access.

The syntax is as follows:

grtv <basedb> <user>

where:

Parameter | Description
<basedb> | Is the name of the base database to which the user is to be granted report views access.
<user> | Is the name of the database user to whom report views access is to be granted. When you create a new base database in Dimensions you get, by default, a <basedb>_rept report user. Subsequently, when you install views using INSV, you can then use GRTV to grant views to the database user <basedb>_rept, or any other database user that you have created manually. For Microsoft SQL Server Enterprise only, if you specify the special user PUBLIC then access to the report views will be granted to all Dimensions users.