Where does Browser get Object Privs on Roles from ?

[ScottMattes]

We just had a problem with a new role, or so I thought, and I used PL/SQL Dev to poke around - trying to find out what was wrong.

The role was suppose to have insert on a table and update on one field of another. Under the Roles entry I could see the table that we could insert to, but I didn't see the field of the other table listed. Since the error was on an update I said 'ah ha!' Wrongo code breath! TOAD shows that the role does have update to the one field and subsequent testing proved that TOAD was correct (I hate having to say that).

So, where is that information coming from and how come PLSD didn't show it?

 

[Marco Kalter]

PL/SQL Developer's Object Browser does not show column-level privileges. Only object-level privileges are displayed.

 

[ScottMattes]

hmmmm, somewhat understandable, but it isn't all that obvious.

please make this an enhancement request.

 

[Marco Kalter]

Okay, I have added this to the list of enhancement requests.

 

[ScottMattes]

Thank you - it was embarassing to have the DBA disparge (even if he did it 'nicely') PL/SQL Dev.