Archives of the TeradataForum

Message Posted: Thu, 03 Dec 2009 @ 15:05:13 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Thursday, December 03, 2009 09:59 -->

Hi all,

I have added a database to the Explorer tree, when I trying to expand it and see the views available, I get an error message "User does not have any access to the database".

But I am able to query all the views in the database. I checked the AccessRights table and user has the read access on the database (Database level).

My questions are:

1) What additional access is needed to be able to see the views available in the database?

2) What query does the SQL Assistant fire to get the view details? (I tried enabling the access logging to see, but strangely I couldn't see any queries being captured, I may be wrong, I did not spend too much time analyzing it)

Thanks.

	<Prev	Next>		<<First	<Prev	Next>	Last>>