Inverse of list

[sjar1290]

Hi Everyone,

I Have a table, in this users have access to the all objects and we are restricting the access to the users at the script

select group, object  from table 1;

Group	Object
Group1	Object 1
Group 2	Object 2
Group 3	Object 3
Group 4	Object 4

what I need is the inverse of that list

how can we do that?

any help would e appreciated

Thanks,

Raj.