DBA Hub

📋Steps in this guide1/1

grant table/column privilege to user

-- Table privileges

oracle configurationintermediate
by OracleDba
12 views
1

grant table/column privilege to user

-- Table privileges -- Grant privilege on few columns of a table --Only INSERT,UPDATE can be granted at COLUMN level.

Code/Command (click line numbers to comment):

1
2
3
4
5
6
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 insert (emp_id) ON TESTUSER1.EMPTABL TO SCOTT;
GRANT UPDATE(emp_id) ON TESTUSER1.EMPTABL TO SCOTT;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!