Re: Grant Re-Generating Script ?
From: Vince Germscheid <Vince_Germscheid_at_cscmail.csc.com>
Date: 1996/10/20
Message-ID: <01bbbe82$41b61ae0$1f1e0814_at_vgermscheid.min.csc.com>#1/1
Date: 1996/10/20
Message-ID: <01bbbe82$41b61ae0$1f1e0814_at_vgermscheid.min.csc.com>#1/1
You can get all of the table level grants from the data dictionary. I believe the view name is ALL_TAB_GRANTS_MADE or USER_TAB_GRANTS_MADE from the schema owner's point of view. I don't have my SQL script handy or I'd post a copy of a script I have which does this.
V.
jchoi_at_sunnyvale.is.lmsc.lockheed.com wrote in article
<53tsae$leh_at_butch.lmsc.lockheed.com>...
> Is there a script that would regenerate all the GRANTs
> that I currently have in the database?
>
> We are migrating DB and have been dropping lots of tables.
>
> --
> John K. Choi
> Lockheed Martin Missiles and Space
> jchoi_at_sunnyvale.is.lmsc.lockheed.com
> +1 408-756-2047
>
Received on Sun Oct 20 1996 - 00:00:00 CEST