I need a mechanism by which certain users are empowered to update some of the columns in a (very small) table, but not all columns. Also, the users should not be able to insert to/delete from this table. Is there an easy way to achieve this?
The users will likely use MS Access via ODBC connection to access the Teradata table.
Do you need the users to be able to view all columns for the table? If not, then you can set up a view layer that only exposes those columns these users are authorized to interact with. Then grant users SELECT/UPDATE access to the VIEW, not the table, and you should be good to go.
If you need them to be able to view all columns of the table but only update some, you should probably look into column-level access rights.
Yes, the users should be able to view all columns. The DBA seems to think that column-level access permission is not possible in Teradata and suggested that this may have to be implemented through procedures (To update the columns the users may have to call a stored procedure with parameters specifying the column and values etc). This seems to me like asking too much from the user. So I was wondering if there is an easier way.