REKV – Revoking Report Views from a Dimensions User

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

The syntax is as follows:

rekv <basedb> <user>

where:

Parameter | Description
<basedb> | Is the name of the base database from which the user's access to the report views will be revoked.
<user> | Is the name of the database user from whom report views access is to be revoked. For Microsoft SQL Server Enterprise only, if you specify the special user PUBLIC then access to the report views will be removed from all Dimensions users.