Position-change of Table Column will remove table-privileges

Position-change of Table Column will remove table-privileges

Postby 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
wcdevart3
 
Posts: 7
Joined: Tue 11 Aug 2015 10:24

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

Postby alexa » Tue 16 Feb 2016 12:17

We will investigate this issue and will answer you as soon as possible.
alexa
Devart Team
 
Posts: 2170
Joined: Fri 24 Jun 2011 14:17

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

Postby wcdevart3 » Tue 29 Nov 2016 08:14

This bug prevents us from using the software in production. Please investigate this issue.
wcdevart3
 
Posts: 7
Joined: Tue 11 Aug 2015 10:24

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

Postby alexa » Tue 29 Nov 2016 11:20

This issue is fixed in the latest version 3.9 https://www.devart.com/dbforge/oracle/studio/download.html
alexa
Devart Team
 
Posts: 2170
Joined: Fri 24 Jun 2011 14:17


Return to dbForge for Oracle