All Forums Third Party Software
flair123 3 posts Joined 10/07
24 Oct 2007
Is update possible in DBC.USERS?

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?Pl reply me......thnks in adv........

Balamurugan B 81 posts Joined 09/07
24 Oct 2007

Hi,Normal generally have only access privilege to DBC.USER table.Regards,Balamurugan

Regards,
Balamurugan

Balamurugan B 81 posts Joined 09/07
24 Oct 2007

Hi,We generally have only access privilege to DBC.USER table.Regards,Balamurugan

Regards,
Balamurugan

flair123 3 posts Joined 10/07
24 Oct 2007

Thanks boss,but i m able to create & delete user in the DBC.USERS view.........pl reply me......

Balamurugan B 81 posts Joined 09/07
24 Oct 2007

Hi,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

Regards,
Balamurugan

wicik 35 posts Joined 06/12
11 Mar 2013

Hi there,
 
Do you guys have idea how to grant full select privilages on dbc.users?
I have been granted with grant select on dbc.users to my_login but i still see only myself in select * from...
 
Any help?

You must sign in to leave a comment.