SQL> create user test_1 identified by test123 default tablespace system quota unlimited on system;User createdSQL> grant create session to test_1;Grant succeededSQL> grant create table to test_1;Grant succeededSQL> conn test_1/test123@stg_bj Connected to Oracle8i Enterprise Edition Release 8.1.7.4.0 Connected as test_1SQL> create table test(userid number);Table createdSQL> revoke insert on test from test_1;revoke insert on test from test_1ORA-01749: you may not GRANT/REVOKE privileges to/from yourselfSQL> conn dbmgr@stg_bj Connected to Oracle8i Enterprise Edition Release 8.1.7.4.0 Connected as dbmgrSQL> revoke insert on test_1.test from test_1;revoke insert on test_1.test from test_1ORA-01927: cannot REVOKE privileges you did not grantSQL>
Connected to Oracle8i Enterprise Edition Release 8.1.7.4.0
Connected as test_1SQL> create table test(userid number);Table createdSQL> revoke insert on test from test_1;revoke insert on test from test_1ORA-01749: you may not GRANT/REVOKE privileges to/from yourselfSQL> conn dbmgr@stg_bj
Connected to Oracle8i Enterprise Edition Release 8.1.7.4.0
Connected as dbmgrSQL> revoke insert on test_1.test from test_1;revoke insert on test_1.test from test_1ORA-01927: cannot REVOKE privileges you did not grantSQL>