|
This procedure permits a DBA to reload special permissions for all databases on a server. This is also the only way to clear out old asymmetric keys for signed assemblies from master.
The procedure starts off with deleting all certitifcates, asymmetric keys and logins created in master by AbaPerls. It then proceeds to call ap_spp_reload_database_sp in each database where this procedure is present.
@report bit = 1 -- Print statements to be executed. @exec bit = 0 -- Execute the statements to grant the permissions.
The @report and @exec parameters permit the DBA to review the script, and he can opt to run the generated script rather than using the @exec option, to be fully sure on what he runs. |
|
|
|