enhancement request

[sukhadukkham]

if you add a column to a table with pldev, pldev does a "revoke select on...".
i would like to have an option for this, as it is very annoying when testing with multiple database user's.

thanks in advance
daniel

 

[Marco Kalter]

I'm not quite sure I understand. Can you provide an example?

 

[sukhadukkham]

steps to reproduce:

create a table with user a.
grant select on this table to user b.
add a column to the table as user a ( pldev will revoke the grant for user b )

 

[Worker]

I can't reproduce this problem. After performing those steps, user b still has select on the table.

Maybe you can give more details? Create the table, how? Grant select, how? Add a column, how? What kind of column are you adding? What version of Oracle? What version of the Oracle client?

 

[sukhadukkham]

1) create a table with the create table dialog ( one column )
2) log in as second user and do a:
select * from all_tab_cols atc where atc.owner = 'yor_owner' and atc.table_name = 'your_table';

=> no rows selected ( that's ok )

3) grant select on 'your_table' to 'second_user'
4) same select on all_tab_cols
=> result: you'll see the table ( that's ok )
5) now add a column with the table dialog and press "view sql" before executing, you will get something like this:

-- Add/modify columns
alter table TEST add B varchar2(1);
-- Grant/Revoke object privileges
revoke select on TEST from OAUDIT;

it doesn't matter which kind of column one adds.

oracle rdbms version is 9.2.0.7 ( client, too )

 

[sukhadukkham]

some more information:

the problem only occurs if you do this with 2 pldev instances open ( first instance connected as user 1 second as user 2 ).
now you should be able to reproduce the above steps

 

[Worker]

I was able to reproduce this now. Hopefully PLSQL Developer Support will be able to as well

 

[Marco Kalter]

The Create Table dialog will always determine the differences between the table definition in the editor and in the database. That is why you see the revoke.