Archives of the TeradataForum

Message Posted: Wed, 21 Jan 2015 @ 16:17:55 GMT

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

Hi Sravan,

Check if your database nodes are on TTU 14.10 and later including TDICU, TeraGSS and TDICU.

If you are on TTU14.10, try giving the below grant.

     grant select on viewpoint to td_sysxml;

also try all the below grants, it may resolve the issue for you.

     grant execute procedure on locklogshredder to "viewpoint"; grant create table on
     "viewpoint" to locklogshredder; grant insert on "viewpoint" to TD_SYSXML;

     GRANT CREATE TABLE ON VIEWPOINT TO DBC;

     modify user viewpoint as default database = 'viewpoint'; grant insert on viewpoint to dbc;

Thanks,

Chiran

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