Cannot manage function-level permissions (bug)

[wokalski]

When I want to add execute on some function to a user:

 permission {
   to         = user.a_user
   for        = function.public.a_function
   privileges = [EXECUTE]
 }

It fails silently. No migration is generated.

[a8m]

Hey! What version do you use?

[luantranminh]

Hi @wokalski ,

I tested permissions on functions/procedures with the latest binary, and everything works as expected.

Could you double-check two things in your setup?

1. Both permissions and roles are enabled, without them, grants/roles are silently ignored.
2. The dev URL uses database mode (not schema mode)

Here's a minimal working config:

env "local" {
  url     = "<your-db-url>"
  dev     = "docker://postgres/16"
  schema {
    mode {
      permissions = true
      roles = true
    }
  }
}

Could you retry with these settings and let us know if the issue persists? If it does, sharing your atlas.hcl and schema file would help us dig further.

[wokalski]

we are using v1.1.3-742b398-canary due to some other bugs fixed in the canary version.

My HCL is as follows:

env "dev" {
  url = format("postgres:///caddie?host=%s&user=postgres&sslmode=disable", getenv("PGHOST"))
  dev = format("postgres:///postgres?host=%s/postgres-dev-sockets&user=postgres", getenv("DEVENV_STATE"))
  schema {
    src = [
      "file://dialo-db/schema",
      "file://dialo-db/schema/roles",
    ]
    mode {
      roles       = true
      permissions = true
    }
  }
  migration {
    dir = "file://dialo-db/migrations"
  }
  diff {
    concurrent_index {
      add  = true
      drop = true
    }
  }
  data {
    mode = SYNC
    include = [
      "*.statuses",
      "*.call_types",
      "*.accepted_statuses",
      "app_public.job_request_status",
      "app_public.request_status",
      "studio_public.dialog_main_purposes",
      "studio_public.permission_kinds",
      "app_public.campaign_role_kind",
    ]
    max_rows = 1000
  }
}

[luantranminh]

@wokalski could you try the latest version by running this command to upgrade Atlas:

curl -sSf https://atlasgo.sh | sh