Oracle column Licensing related tests

Create tablespace liangtbs datafile '/home/oradata/lgjdb/liangtbs01.dbf ' size 50m autoextend on;create tablespace Testtbs datafile '/home/oradata/lgjdb/testtbs01.dbf ' size 50m autoextend on;

CREATE USER Junuser identified by "Oracle"
DEFAULT tablespace Liangtbs
Temporary tablespace TEMP;

CREATE TABLE T_test (ID number,table_name varchar2 (50),
Owner VARCHAR2 (+), Tablespace_name varchar2 (50));

INSERT into t_test values (1, ' table_name ', ' guouser ', ' tablespace_name ');

Col ID for 99999999
Col table_name for A20
Col owner for A20
Col Tablespace_name for A20

#如下授权是错误的, you cannot recycle a column
Revoke UPDATE (OWNER) on Lianguser. T_test from Lianguser;

Grant create session to Junuser;
Grant CREATE TABLE to Junuser;
GRANT RESOURCE to Junuser;
Grant Select any table to Junuser;
ALTER USER junuser QUOTA UNLIMITED on Liangtbs;

Grant Select,insert,update,delete,alter,index on Guouser. T_test to Junuser;

Grant UPDATE on Guouser. T_test to Junuser;
Revoke UPDATE on Guouser. T_test from Junuser;

Grant UPDATE (Table_name,tablespace_name) on Guouser. T_test to Junuser;

Conclusion: For the owner of the table, it is not possible to reclaim its update permissions,
For example, Guouser.t_test table, cannot reclaim revoke UPDATE on Guouser. T_test from Guouser;

Oracle column Licensing related tests