Position-change of Table Column will remove table-privileges
Posted: Wed 10 Feb 2016 11:04
When moving a column position with drag and drop an saving the changed table -> the table privileges (grants) are removed, but not recreated.
dbForge Studio for Oracle Version: Professional Edition 3.8.40
Oracle-Version: 11g
-- create table and privilege
-- the used schema-User has CONNECT and RESOURCE-privilege
CREATE TABLE TESTTABLE (
TESTCOLUMN VARCHAR2(50 BYTE),
TESTCOLUMN2 VARCHAR2(50 BYTE),
CONSTRAINT PK_TESTTABLE PRIMARY KEY (TESTCOLUMN));
-- sample table privilege to another schema-user
grant select on testtable to system;
-- show table privileges
select * from user_tab_privs where table_name = 'TESTTABLE';
-- use dbForge to edit table, change the 2 column positions, save -> no more table privileges
dbForge Studio for Oracle Version: Professional Edition 3.8.40
Oracle-Version: 11g
-- create table and privilege
-- the used schema-User has CONNECT and RESOURCE-privilege
CREATE TABLE TESTTABLE (
TESTCOLUMN VARCHAR2(50 BYTE),
TESTCOLUMN2 VARCHAR2(50 BYTE),
CONSTRAINT PK_TESTTABLE PRIMARY KEY (TESTCOLUMN));
-- sample table privilege to another schema-user
grant select on testtable to system;
-- show table privileges
select * from user_tab_privs where table_name = 'TESTTABLE';
-- use dbForge to edit table, change the 2 column positions, save -> no more table privileges