Position-change of Table Column will remove table-privileges

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
wcdevart3
Posts: 7
Joined: Tue 11 Aug 2015 10:24

Position-change of Table Column will remove table-privileges

Post by wcdevart3 » 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

alexa

Re: Position-change of Table Column will remove table-privileges

Post by alexa » Tue 16 Feb 2016 12:17

We will investigate this issue and will answer you as soon as possible.

wcdevart3
Posts: 7
Joined: Tue 11 Aug 2015 10:24

Re: Position-change of Table Column will remove table-privileges

Post by wcdevart3 » Tue 29 Nov 2016 08:14

This bug prevents us from using the software in production. Please investigate this issue.


Post Reply