grant table/column privilege to user - Oracle Database Script. -- Table privileges GRANT READ ANY TABLE TO SCOTT; GRANT SELECT ANY TABLE TO SCOTT; GRANT INSERT, UPDATE, DELETE ON TESTUSER1.EMPTABL on SCOTT; GRANT ALL ON TESTUSER1.EMPTABL on SCOTT; -- Grant privilege on few columns of a table --Only INSERT,UPDATE can be granted at COLUMN level. GRANT insert (emp_id) ON TESTUSER1.EMPTABL TO SCOTT; GRANT UPDATE(emp_id) ON TESTUSER1.EMPTABL TO SCOTT;
-- Table privileges GRANT READ ANY TABLE TO SCOTT; GRANT SELECT ANY TABLE TO SCOTT; GRANT INSERT, UPDATE, DELETE ON TESTUSER1.EMPTABL on SCOTT; GRANT ALL ON TESTUSER1.EMPTABL on SCOTT; -- Grant privilege on few columns of a table --Only INSERT,UPDATE can be granted at COLUMN level. GRANT insert (emp_id) ON TESTUSER1.EMPTABL TO SCOTT; GRANT UPDATE(emp_id) ON TESTUSER1.EMPTABL TO SCOTT;