|
This procedure iterates over the objects in abaspecialperms and calls ap_spp_grant_perms for each object. Thus, this procedure acertains that all permissions in the server match those in abaspecialperms. Before reloading permissions, the procedure drops all certificates and certificate users created by AbaPerls from the database, and likewise it drops certificates and logins in master where the certificate subject matches the database name. The procedure does not drop any asymmteric keys for assemblies.
If the database is part of an availavibility group, the procedure executes the server-level commands on the other nodes in the AG as well.
Parameters: @report bit = 1 -- Print the statements to be executed. @exec bit = 0 -- Execute the statements to grant the permissions. @notuse char(2) = NULL -- Not used, exists for backwards compatibility.
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. Note that the default is to print only. |
|
|
|