All Forums Database
sirdimko1981 3 posts Joined 02/12
24 Feb 2012
Problems with two views on different Databases

Hi.

Two databases are exists.

 

The first view layout at db1. I named it VIEW1, the secont view layout at db2, I named it VIEW2.

VIEW2 linked with VIEW1:

 

CREATE VIEW DB2.VIEW2 AS

LOCKING ROW ACCESS

SEL v.field1

FROM DB1.VIEW1 v;

 

 When I connected to TD server as user "dbc" and execute "select * from VIEW2", 

teradata show an error:

 

SELECT Failed. 5315:  An owner referenced by user does not have SELECT WITH GRANT OPTION access to DB1.VIEW1.field1. 

 

WHY??? DBC has max rights access.

 

Thanks in advance. 

 

 

ulrich 816 posts Joined 09/09
24 Feb 2012

The database where the view is stored need select rights with grant option on the source table (or DB).

check http://www.teradataforum.com/teradata/20040908_102929.htm

 

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

sirdimko1981 3 posts Joined 02/12
26 Feb 2012

Thanks!

lappylook 1 post Joined 05/12
01 May 2012

The link mentioned here is not working..I checked in archives but could not find.. can you please repost the correct link.

 

Thanks in advance...

Regards,

Lappy!

ulrich 816 posts Joined 09/09
01 May 2012

http://www.teradataforum.com/teradata/20040908_102929.htm

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

Krupakaran 7 posts Joined 07/12
21 Sep 2012

http://www.teradataforum.com/teradata/20040908_102929.htm - this link will work, there is a space in the URL :).

You must sign in to leave a comment.