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
Position-change of Table Column will remove table-privileges
Re: Position-change of Table Column will remove table-privileges
We will investigate this issue and will answer you as soon as possible.
Re: Position-change of Table Column will remove table-privileges
This bug prevents us from using the software in production. Please investigate this issue.
Re: Position-change of Table Column will remove table-privileges
This issue is fixed in the latest version 3.9 https://www.devart.com/dbforge/oracle/s ... nload.html