ss

Oracle Tips by Burleson

Column Privileges

Only INSERT, UPDATE, and REFERENCES privileges can be granted at the column level. When granting INSERT at the column level, you must include all the NOT NULL columns in the row.

See Code Depot

For example:

GRANT update (emp_id,emp_name)

See Code Depot

As the DBA, you can access the DBA_COL_PRIVS view for information on the object privileges granted to users.

Users can access the USER_COL_PRIVS_RECD view for information on column privileges that have been granted to them. The ALL_COL_PRIVS_RECD view includes information on all column privileges that have been granted to them or to PUBLIC.

Users can access the USER_COL_PRIVS_MADE view for information on column privileges that they have granted to others. The corresponding ALL_COL_PRIVS_MADE view includes information on all columns for which the user is the owner or the grantor.

Users can access information on all columns for which they are the grantor, grantee, or owner, or for which access has been granted to PUBLIC with the corresponding ALL_TAB_PRIVS_MADE and ALL_TAB_PRIVS_RECD views