Skip to content

Releases: pragmatic-data/sf-admin

Add grant option on DB usage for RW roles

Choose a tag to compare

@RobMcZag RobMcZag released this 08 Sep 10:27
2a1c23d

By granting DB usage with grant option to RW we enable the user executing the project code in dbt to grant usage on the DB to new roles, along with usage on the schemas and select on tables and views.

For now leaving out the ability to grant usage of the WH, as WH assignment might follow a different logic than the usual code ownership/data access.

Bumped up the version to 1.0.2

Initial public release

Choose a tag to compare

@RobMcZag RobMcZag released this 05 May 06:42
be6924c

This initial release has the core functionalities to create a proper set of environments for a professional set up.
This includes:

  • creation of databases for the envs
  • creation of warehouses for the envs,
    even if by default we create a shared WH that is more suitable in the beginng
  • creation of roles to grant RO or RW access to the envs
  • creation of roles to provide mindful access to the core types of users
    (executor, developer and reader) that can be defined before a project is even started
  • utilities to assign user to these roles or to new roles created later.