Object Privileges  «Prev 

INSERT with limited Access to Columns

What happens when a user has limited access to a column?

If a user performs one of these operations, any columns that the user does not have access to will receive NULL values, as shown in the images below

The EMP table has six columns - 1) NAME, 2) ADDRESS, 3) CITY, 4) STATE, 5) ZIP, and 6) SALARY

The current user does not have INSERT privilege for the SALARY column

If the user were to insert a value for the SALARY column, an error would be returned

If the user were to insert only values for the five columns for which he or she has INSERT privileges, the SALARY column would be assigned the NULL value