Usage.asp error access is denied

[Janaina]

KVS admin account can view the page fine, however,  Role based admin(Message Administrators) are getting access denied. Checked IIS its using basic authentication only.

[beta_dodo]

Hi,

I'm pretty sure that you'll need to give the RBA users access to sql as well(directory and vault store databases)

[Rob_Vollum]

Yes, you do. At least I did.

Below is a link to a tech note that tells what to do. The extra access required here was enough for my client to realize that usage.asp is really a VSA report, and not meant for all users. EV Reports have an equivalent report that works great, and they are happy with that. That said, here's the link:

http://seer.entsupport.symantec.com/docs/287580.htm

It boils down to this:

Add the RBA user as a login in SQL Server

 

Add it as a user mapping to the EV Vault Store databases

 

In all the vault store databases:

GRANT EXECUTE ON usps_Usage TO domain\user

GRANT SELECT ON view_ListVaults TO domain\user

HTH,

Rob