The following statement grants INSERT privilege on the acct_no column of the accounts table to scott:
GRANT INSERT (acct_no) ON accounts TO scott;
In another example, object privilege for the ename and job columns of the emp table are granter to the users jfee and tsmith:
GRANT INSERT(ename, job) ON emp TO jfee, tsmith;
