Add default privileges in add_role function

[jfinzel]

add_role function should be written such that with new tables/sequences added in extension, existing roles that have privileges on pgl_ddl_deploy tables get perms to new tables without the update extension script handling that.