3524 The user does not have any access to database EDW

Tools
N/A

3524 The user does not have any access to database EDW

Hello,

At our site we have granted select access to views in database EDW to xxxx_DR (data role) and then xxxx_DR is grated to yyyy_UR (User role) and yyyy_UR is granted to user a.

When user a login to SQL assistant 7.1 and adds EDW database to left pane, after double click views in EDW database, following message thrown "3524 the user does not have any access to database EDW".

But if user executes select count (*) from EDW.zzzz on views he/she has access then result is displayed.

I an nor sure if there is any ODBC setting required so that SQL Assistant 7.1 can display list of views which user has access.

Thanks in Advance

Prakash
2 REPLIES
Enthusiast

Re: 3524 The user does not have any access to database EDW

tr recompling any sp's or macros associated in applicable.
Fan

Re: 3524 The user does not have any access to database EDW

You are talking about an issue with the Database Explorer.

It can be solved pretty easily.  I followed the instructions here:

http://how.best-free-information.com/2012/10/how-to-fix-teradata-the-user-does-not-have-any-access-t...

Basically you configure your ODBC connection with the 'No HELP DATABASE' option.  I have no idea why that works, but it does. :)