Table Privileges

I have "inherited" a database, with a script somewhere, that does this crazy privilege grants on some of our tables. First question: How do I Clear the below privileges on existing tables - for example, if you look at the last 3 lines, user "sasuser" has both All and None privileges. How do I clean this up ? User Select Update Insert Delete Index Alter SU_ISSAS All All Yes Yes Yes Yes public All All Yes Yes Yes Yes sasuser None None No No No No sasuser All All Yes Yes Yes Yes su_issas All All Yes Yes Yes Yes su_issas None None No No No No

Hi Dirk. It can sometimes be easier just to delete rows from "systabauth" and "syscolauth" for the affected table IDs before running grant statements from a clean position. Be careful and never delete data for "tabid < 100" as those relate to system tables. Regards, Doug Lawry