Hi all, I got this query with error. [color=11] [size=5]QUERY: UPDATE DBC.USERS SET UserName='John' WHERE UserName='Jones' and CreatorName='td2idm'
ERROR: com.ncr.teradata.jdbc_4.util.JDBCException: [NCR] [Teradata DBMS] : VIEW 'USERS' may not be used for Help Index/Constraint/Statistics, Update, Delete or Insert.[/size][/color] Is this error due to Access privilege restriction or Update not possible in DBC.USERS View?
In your example you are trying to update a record through DBC.USERS view, for which you should have update privilege to the actual table. As we don't have update privilege for DBC.USERS table your query throws an error.