InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comFri, 29 Aug 2008 16:08:23 GMT20http://www.teradata.com/teradataforum/Topic9403-12-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,BalamuruganWed, 24 Oct 2007 07:11:21 GMTBalamurugan Bhttp://www.teradata.com/teradataforum/Topic9403-12-1.aspxThanks boss,but i m able to create & delete user in the DBC.USERS view.........pl reply me......Wed, 24 Oct 2007 06:24:17 GMTflair123http://www.teradata.com/teradataforum/Topic9403-12-1.aspxHi,We generally have only access privilege to DBC.USER table.Regards,Balamurugan Wed, 24 Oct 2007 05:57:18 GMTBalamurugan Bhttp://www.teradata.com/teradataforum/Topic9403-12-1.aspxHi,Normal generally have only access privilege to DBC.USER table.Regards,BalamuruganWed, 24 Oct 2007 05:56:09 GMTBalamurugan Bhttp://www.teradata.com/teradataforum/Topic9403-12-1.aspxHi 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?Pl reply me......thnks in adv........Wed, 24 Oct 2007 05:49:18 GMTflair123