InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 15:44:53 GMT20http://www.teradata.com/teradataforum/Topic9399-5-1.aspxHi,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.Regards,Balamurugan Wed, 24 Oct 2007 07:54:51 GMTBalamurugan Bhttp://www.teradata.com/teradataforum/Topic9399-5-1.aspxQUERY: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. Wed, 24 Oct 2007 05:40:40 GMTgobinath