|
This procedure grants permissions to an object, be that a module or an assembly, that needs special permissions as specified in abaspecialperms.
The procedure is called by AbaPerls when an object is loaded. The procedure can also be used by a DBA to complete granting of server-level permissions when the original user did not have permission to do this. Note that calling this procedure directly will not set the permissions on the other nodes in an availability group.
Parameters: @objname sysname -- the object. @report bit = 1 -- Print statements to be executed. @exec bit = 0 -- Execute the statements to grant the permissions. @alreadydeleted char(2) = NULL -- Internal use only.
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. |
|
|
|