Archives of the TeradataForum

Message Posted: Sun, 09 Sep 2012 @ 15:12:23 GMT

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

Hi all,

Whilst doing some work I came across the following security error code (5315). I've always been used to checking for a 3523 as a security error code.

What is the difference between the two (and please don't say 1792 !) ? When can we expect to receive one error code or the other ?

I have checked the TD 13.10/TD14.0 ?Messages manuals and the descriptions are virtually identical, as shown below.

3523 %FSTR does not have %VSTR access to %DBID.%TVMID.

Explanation: The user does not have the proper access rights to execute this request, or the owner of the requested view or macro does not have the proper access rights to underlying tables.

Generated By: SQL modules.

For Whom: End User.

Remedy: Obtain the necessary access rights.

5315 %FSTR does not have %VSTR access to %DBID.%TVMID.%FLDID.

Explanation: The user does not have the proper access rights to execute this request, or the owner of the requested view or macro does not have the proper access rights to underlying tables.

Generated By: SQL modules.

For Whom: End User.

Cheers,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)

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