Video Screencast Help
Search Video Help Close Back
to help
New in the Rewards Catalog: Vouchers for "Symantec Technical Specialist" and "Symantec Certified Specialist" exams.

Usage.asp error access is denied

Updated: 21 May 2010 | 2 comments
Janaina's picture
0 0 Votes
Login to vote

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.

discussion Filed Under:

Comments

beta dodo's picture
03
Dec
2008
0 Votes 0
Login to vote

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's picture
03
Dec
2008
0 Votes 0
Login to vote

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