Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Resources and role_grants are not running in the correct order --maybe? #119

Open
dsmdavid opened this issue Oct 9, 2024 · 6 comments
Open

Resources and role_grants are not running in the correct order --maybe? #119

dsmdavid opened this issue Oct 9, 2024 · 6 comments
Labels
bug Something isn't working

Comments

@dsmdavid
Copy link

dsmdavid commented Oct 9, 2024 •
edited
Loading

[titan-core=0.9.1]
Not sure if it's a bug or if I'm missing something.
I have a yaml configuration that contains

-roles
-role_grants
-databases
-warehouses
-grants
-future_grants
-grants_on_all

that fails with an error Insufficient privileges to operate on database 'TRANSFORM_TITAN' when trying to create one of the schemas (different one each time) in one of the databases that is owned by a custom role.
e.g. [titanadmin:SYSADMIN] > CREATE SCHEMA TRANSFORM_TITAN.MART_FINANCE DATA_RETENTION_TIME_IN_DAYS = 1 MAX_DATA_EXTENSION_TIME_IN_DAYS = 14 (err 3001, 0.10s)

If I make a copy of that configuration and remove everything after role_grants, the first run succeeds.
If I now run again the original configuration, it also succeeds.

What I think it's happening is that the order of the statements is something like:

  • creates some roles (including the to-be database owner)
  • creates the database (and grant ownership to the custom role)
  • attempts to create the schema as sysadmin before the role_grants have been executed.

If the above is correct, not sure if it's a resource lineage not tracked or if it could be solved by creating roles first, then role_grants then everything else.

Below I paste the config file that is showing the error. Apologies for the long file -- I tried minimizing the config but then the error was not reproducible all the time (sometimes it errored, sometimes it didn't), so I have just removed everything after databases but left the roles and role_grants.

roles:
# access roles 
  - name: AR__DB__RAW_TITAN__RO
    owner: SECURITYADMIN
  - name: AR__DB__RAW_TITAN__RW
    owner: SECURITYADMIN
  - name: AR__DB__RAW_TITAN__ADMIN
    owner: SECURITYADMIN
  - name: AR__SC__RAW_TITAN__REFERENCE__RO
    owner: SECURITYADMIN
  - name: AR__SC__RAW_TITAN__REFERENCE__RW
    owner: SECURITYADMIN
  - name: AR__SC__RAW_TITAN__REFERENCE__ADMIN
    owner: SECURITYADMIN
  - name: AR__SC__RAW_TITAN__SOURCE_SYSTEM_1__RO
    owner: SECURITYADMIN
  - name: AR__SC__RAW_TITAN__SOURCE_SYSTEM_1__RW
    owner: SECURITYADMIN
  - name: AR__SC__RAW_TITAN__SOURCE_SYSTEM_1__ADMIN
    owner: SECURITYADMIN
  - name: AR__SC__RAW_TITAN__SOURCE_SYSTEM_2__RO
    owner: SECURITYADMIN
  - name: AR__SC__RAW_TITAN__SOURCE_SYSTEM_2__RW
    owner: SECURITYADMIN
  - name: AR__SC__RAW_TITAN__SOURCE_SYSTEM_2__ADMIN
    owner: SECURITYADMIN
  - name: AR__DB__TRANSFORM_TITAN__RO
    owner: SECURITYADMIN
  - name: AR__DB__TRANSFORM_TITAN__RW
    owner: SECURITYADMIN
  - name: AR__DB__TRANSFORM_TITAN__ADMIN
    owner: SECURITYADMIN
  - name: AR__SC__TRANSFORM_TITAN__STG_REFERENCE__RO
    owner: SECURITYADMIN
  - name: AR__SC__TRANSFORM_TITAN__STG_REFERENCE__RW
    owner: SECURITYADMIN
  - name: AR__SC__TRANSFORM_TITAN__STG_REFERENCE__ADMIN
    owner: SECURITYADMIN
  - name: AR__SC__TRANSFORM_TITAN__STG_SOURCE_SYSTEM_1__RO
    owner: SECURITYADMIN
  - name: AR__SC__TRANSFORM_TITAN__STG_SOURCE_SYSTEM_1__RW
    owner: SECURITYADMIN
  - name: AR__SC__TRANSFORM_TITAN__STG_SOURCE_SYSTEM_1__ADMIN
    owner: SECURITYADMIN
  - name: AR__SC__TRANSFORM_TITAN__STG_SOURCE_SYSTEM_2__RO
    owner: SECURITYADMIN
  - name: AR__SC__TRANSFORM_TITAN__STG_SOURCE_SYSTEM_2__RW
    owner: SECURITYADMIN
  - name: AR__SC__TRANSFORM_TITAN__STG_SOURCE_SYSTEM_2__ADMIN
    owner: SECURITYADMIN
  - name: AR__SC__TRANSFORM_TITAN__COMMON__RO
    owner: SECURITYADMIN
  - name: AR__SC__TRANSFORM_TITAN__COMMON__RW
    owner: SECURITYADMIN
  - name: AR__SC__TRANSFORM_TITAN__COMMON__ADMIN
    owner: SECURITYADMIN
  - name: AR__SC__TRANSFORM_TITAN__MART_FINANCE__RO
    owner: SECURITYADMIN
  - name: AR__SC__TRANSFORM_TITAN__MART_FINANCE__RW
    owner: SECURITYADMIN
  - name: AR__SC__TRANSFORM_TITAN__MART_FINANCE__ADMIN
    owner: SECURITYADMIN
  - name: AR__SC__TRANSFORM_TITAN__MART_OPERATIONS__RO
    owner: SECURITYADMIN
  - name: AR__SC__TRANSFORM_TITAN__MART_OPERATIONS__RW
    owner: SECURITYADMIN
  - name: AR__SC__TRANSFORM_TITAN__MART_OPERATIONS__ADMIN
    owner: SECURITYADMIN
  - name: AR__SC__TRANSFORM_TITAN__REPORTING__RO
    owner: SECURITYADMIN
  - name: AR__SC__TRANSFORM_TITAN__REPORTING__RW
    owner: SECURITYADMIN
  - name: AR__SC__TRANSFORM_TITAN__REPORTING__ADMIN
    owner: SECURITYADMIN
  - name: AR__WH__INGEST_TITAN__USE
    owner: SECURITYADMIN
  - name: AR__WH__INGEST_TITAN__ADMIN
    owner: SECURITYADMIN
  - name: AR__WH__TRANSFORM_TITAN__USE
    owner: SECURITYADMIN
  - name: AR__WH__TRANSFORM_TITAN__ADMIN
    owner: SECURITYADMIN
  - name: AR__WH__ADMIN_TITAN__USE
    owner: SECURITYADMIN
  - name: AR__WH__ADMIN_TITAN__ADMIN
    owner: SECURITYADMIN
  - name: AR__WH__REPORT_TITAN__USE
    owner: SECURITYADMIN
  - name: AR__WH__REPORT_TITAN__ADMIN
    owner: SECURITYADMIN
# functional roles
  - name: FR__DB_ADMIN_TITAN
    owner: SECURITYADMIN
    comment: "Database manager."
  - name: FR__INGEST_TITAN
    owner: SECURITYADMIN
    comment: "Owns the tables in your raw database, and connects to the loading warehouse."
  - name: FR__TRANSFORM_TITAN
    owner: SECURITYADMIN
    comment: "Has query permissions on tables in raw database and owns tables in the analytics database. This is for dbt developers and scheduled jobs."
  - name: FR__REPORT_TITAN
    owner: SECURITYADMIN
    comment: "Has permissions on the reporting layer in the analytics database only. This role is for data consumers, such as analysts and BI tools. These users will not have permissions to read data from the raw database."
  - name: FR__OPERATIONS_TITAN
    owner: SECURITYADMIN
    comment: "Has permissions on the reporting layer and in the specific marts for the domain."
  - name: FR__FINANCE_TITAN
    owner: SECURITYADMIN
    comment: "Has permissions on the reporting layer and in the specific marts for the domain."
  - name: WH__ADMIN_TITAN  
    owner: SECURITYADMIN
    comment: "Warehouse manager."


role_grants:

# role hierarchy
  - role: AR__DB__RAW_TITAN__RO
    to_role: AR__DB__RAW_TITAN__RW
  - role: AR__DB__RAW_TITAN__RW
    to_role: AR__DB__RAW_TITAN__ADMIN
  - role: AR__SC__RAW_TITAN__REFERENCE__RO
    to_role: AR__SC__RAW_TITAN__REFERENCE__RW
  - role: AR__SC__RAW_TITAN__REFERENCE__RW
    to_role: AR__SC__RAW_TITAN__REFERENCE__ADMIN
  - role: AR__SC__RAW_TITAN__REFERENCE__ADMIN
    to_role: AR__DB__RAW_TITAN__ADMIN
  - role: AR__SC__RAW_TITAN__SOURCE_SYSTEM_1__RO
    to_role: AR__SC__RAW_TITAN__SOURCE_SYSTEM_1__RW
  - role: AR__SC__RAW_TITAN__SOURCE_SYSTEM_1__RW
    to_role: AR__SC__RAW_TITAN__SOURCE_SYSTEM_1__ADMIN
  - role: AR__SC__RAW_TITAN__SOURCE_SYSTEM_1__ADMIN
    to_role: AR__DB__RAW_TITAN__ADMIN
  - role: AR__SC__RAW_TITAN__SOURCE_SYSTEM_2__RO
    to_role: AR__SC__RAW_TITAN__SOURCE_SYSTEM_2__RW
  - role: AR__SC__RAW_TITAN__SOURCE_SYSTEM_2__RW
    to_role: AR__SC__RAW_TITAN__SOURCE_SYSTEM_2__ADMIN
  - role: AR__SC__RAW_TITAN__SOURCE_SYSTEM_2__ADMIN
    to_role: AR__DB__RAW_TITAN__ADMIN
  - role: AR__DB__TRANSFORM_TITAN__RO
    to_role: AR__DB__TRANSFORM_TITAN__RW
  - role: AR__DB__TRANSFORM_TITAN__RW
    to_role: AR__DB__TRANSFORM_TITAN__ADMIN
  - role: AR__SC__TRANSFORM_TITAN__STG_REFERENCE__RO
    to_role: AR__SC__TRANSFORM_TITAN__STG_REFERENCE__RW
  - role: AR__SC__TRANSFORM_TITAN__STG_REFERENCE__RW
    to_role: AR__SC__TRANSFORM_TITAN__STG_REFERENCE__ADMIN
  - role: AR__SC__TRANSFORM_TITAN__STG_REFERENCE__ADMIN
    to_role: AR__DB__TRANSFORM_TITAN__ADMIN
  - role: AR__SC__TRANSFORM_TITAN__STG_SOURCE_SYSTEM_1__RO
    to_role: AR__SC__TRANSFORM_TITAN__STG_SOURCE_SYSTEM_1__RW
  - role: AR__SC__TRANSFORM_TITAN__STG_SOURCE_SYSTEM_1__RW
    to_role: AR__SC__TRANSFORM_TITAN__STG_SOURCE_SYSTEM_1__ADMIN
  - role: AR__SC__TRANSFORM_TITAN__STG_SOURCE_SYSTEM_1__ADMIN
    to_role: AR__DB__TRANSFORM_TITAN__ADMIN
  - role: AR__SC__TRANSFORM_TITAN__STG_SOURCE_SYSTEM_2__RO
    to_role: AR__SC__TRANSFORM_TITAN__STG_SOURCE_SYSTEM_2__RW
  - role: AR__SC__TRANSFORM_TITAN__STG_SOURCE_SYSTEM_2__RW
    to_role: AR__SC__TRANSFORM_TITAN__STG_SOURCE_SYSTEM_2__ADMIN
  - role: AR__SC__TRANSFORM_TITAN__STG_SOURCE_SYSTEM_2__ADMIN
    to_role: AR__DB__TRANSFORM_TITAN__ADMIN
  - role: AR__SC__TRANSFORM_TITAN__COMMON__RO
    to_role: AR__SC__TRANSFORM_TITAN__COMMON__RW
  - role: AR__SC__TRANSFORM_TITAN__COMMON__RW
    to_role: AR__SC__TRANSFORM_TITAN__COMMON__ADMIN
  - role: AR__SC__TRANSFORM_TITAN__COMMON__ADMIN
    to_role: AR__DB__TRANSFORM_TITAN__ADMIN
  - role: AR__SC__TRANSFORM_TITAN__MART_FINANCE__RO
    to_role: AR__SC__TRANSFORM_TITAN__MART_FINANCE__RW
  - role: AR__SC__TRANSFORM_TITAN__MART_FINANCE__RW
    to_role: AR__SC__TRANSFORM_TITAN__MART_FINANCE__ADMIN
  - role: AR__SC__TRANSFORM_TITAN__MART_FINANCE__ADMIN
    to_role: AR__DB__TRANSFORM_TITAN__ADMIN
  - role: AR__SC__TRANSFORM_TITAN__MART_OPERATIONS__RO
    to_role: AR__SC__TRANSFORM_TITAN__MART_OPERATIONS__RW
  - role: AR__SC__TRANSFORM_TITAN__MART_OPERATIONS__RW
    to_role: AR__SC__TRANSFORM_TITAN__MART_OPERATIONS__ADMIN
  - role: AR__SC__TRANSFORM_TITAN__MART_OPERATIONS__ADMIN
    to_role: AR__DB__TRANSFORM_TITAN__ADMIN
  - role: AR__SC__TRANSFORM_TITAN__REPORTING__RO
    to_role: AR__SC__TRANSFORM_TITAN__REPORTING__RW
  - role: AR__SC__TRANSFORM_TITAN__REPORTING__RW
    to_role: AR__SC__TRANSFORM_TITAN__REPORTING__ADMIN
  - role: AR__SC__TRANSFORM_TITAN__REPORTING__ADMIN
    to_role: AR__DB__TRANSFORM_TITAN__ADMIN
  - role: AR__DB__RAW_TITAN__ADMIN
    to_role: FR__DB_ADMIN_TITAN
  - role: AR__DB__TRANSFORM_TITAN__ADMIN
    to_role: FR__DB_ADMIN_TITAN
  - role: AR__WH__ADMIN_TITAN__USE
    to_role: FR__DB_ADMIN_TITAN
  - role: FR__DB_ADMIN_TITAN
    to_role: SYSADMIN
  - role: AR__DB__RAW_TITAN__RW
    to_role: FR__INGEST_TITAN
  - role: AR__WH__INGEST_TITAN__USE
    to_role: FR__INGEST_TITAN
  - role: FR__INGEST_TITAN
    to_role: SYSADMIN
  - role: AR__DB__RAW_TITAN__RO
    to_role: FR__TRANSFORM_TITAN
  - role: AR__DB__TRANSFORM_TITAN__RW
    to_role: FR__TRANSFORM_TITAN
  - role: AR__WH__TRANSFORM_TITAN__USE
    to_role: FR__TRANSFORM_TITAN
  - role: FR__TRANSFORM_TITAN
    to_role: SYSADMIN
  - role: AR__SC__TRANSFORM_TITAN__REPORTING__RO
    to_role: FR__REPORT_TITAN
  - role: AR__WH__TRANSFORM_TITAN__USE
    to_role: FR__REPORT_TITAN
  - role: FR__REPORT_TITAN
    to_role: SYSADMIN
  - role: AR__SC__TRANSFORM_TITAN__REPORTING__RO
    to_role: FR__OPERATIONS_TITAN
  - role: AR__SC__TRANSFORM_TITAN__MART_OPERATIONS__RO
    to_role: FR__OPERATIONS_TITAN
  - role: AR__WH__REPORT_TITAN__USE
    to_role: FR__OPERATIONS_TITAN
  - role: FR__OPERATIONS_TITAN
    to_role: SYSADMIN
  - role: AR__SC__TRANSFORM_TITAN__REPORTING__RO
    to_role: FR__FINANCE_TITAN
  - role: AR__SC__TRANSFORM_TITAN__MART_FINANCE__RO
    to_role: FR__FINANCE_TITAN
  - role: AR__WH__REPORT_TITAN__USE
    to_role: FR__FINANCE_TITAN
  - role: FR__FINANCE_TITAN
    to_role: SYSADMIN
  - role: AR__WH__ADMIN_TITAN__ADMIN
    to_role: WH__ADMIN_TITAN
  - role: AR__WH__TRANSFORM_TITAN__ADMIN
    to_role: WH__ADMIN_TITAN
  - role: AR__WH__INGEST_TITAN__ADMIN
    to_role: WH__ADMIN_TITAN
  - role: AR__WH__REPORT_TITAN__ADMIN
    to_role: WH__ADMIN_TITAN
  - role: WH__ADMIN_TITAN
    to_role: SYSADMIN

databases:
  - name: raw_titan
    owner: AR__DB__RAW_TITAN__ADMIN
    comment: "This database contains your raw data. This is the landing pad for everything extracted and loaded, as well as containing external stages for data living in S3. Access to this database is strictly permissioned."
    schemas:
      - name: reference
        owner: AR__SC__RAW_TITAN__REFERENCE__ADMIN
        managed_access: true
      - name: source_system_1
        owner: AR__SC__RAW_TITAN__SOURCE_SYSTEM_1__ADMIN
        managed_access: true
      - name: source_system_2
        managed_access: true
        owner: AR__SC__RAW_TITAN__SOURCE_SYSTEM_1__ADMIN
  - name: transform_titan
    owner: AR__DB__TRANSFORM_TITAN__ADMIN
    comment: "This database contains tables and views accessible to analysts and reporting. Everything in analytics is created and owned by dbt."
    schemas:
      - name: stg_reference
      - name: stg_source_system_1
      - name: stg_source_system_2
      - name: common
      - name: mart_operations
      - name: mart_finance
      - name: reporting
    ```
@teej
Copy link
Collaborator

teej commented Oct 10, 2024

Thanks for the detailed report. For configs like this, Titan uses your grant config to decide how to handle custom owners. But I don't think it handles role trees currently.

I will repro locally and get a fix in an upcoming release.

@teej teej added the bug Something isn't working label Oct 10, 2024
@teej
Copy link
Collaborator

teej commented Oct 24, 2024

I have an initial fix, but it still causes errors occasionally. Going to take a second look next week.

@GJMcClintock
Copy link

I think I'm running into a similar issue. Starting from scratch on a brand new account - have my confing yml completed. I have databases set in the config yml, but get an error that it is trying to grant to the role without ever creating the database:

[garrett:ACCOUNTADMIN] > SHOW ROLES IN ACCOUNT    (6 rows, 0.40s)
[garrett:ACCOUNTADMIN] > SHOW WAREHOUSES IN ACCOUNT    (2 rows, 0.15s)
[garrett:ACCOUNTADMIN] > SHOW GRANTS TO ROLE REPORTER    (empty, 0.16s)
[garrett:ACCOUNTADMIN] > SHOW GRANTS TO ROLE DEVELOPER    (empty, 0.14s)
[garrett:ACCOUNTADMIN] > SHOW GRANTS TO ROLE PROD_W    (empty, 0.19s)
[garrett:ACCOUNTADMIN] > SHOW GRANTS TO ROLE DEV_W    (empty, 0.21s)
[garrett:ACCOUNTADMIN] > SHOW GRANTS TO ROLE STAGE_W    (empty, 0.16s)
[garrett:ACCOUNTADMIN] > SHOW GRANTS TO ROLE CICD_W    (empty, 0.19s)
[garrett:ACCOUNTADMIN] > SHOW GRANTS TO ROLE RAW_DEV_W    (empty, 0.13s)
[garrett:ACCOUNTADMIN] > SHOW GRANTS TO ROLE RAW_W    (empty, 0.13s)
[garrett:ACCOUNTADMIN] > SHOW GRANTS TO ROLE PROD_R    (empty, 0.13s)
[garrett:ACCOUNTADMIN] > SHOW GRANTS TO ROLE DEV_R    (empty, 0.11s)
[garrett:ACCOUNTADMIN] > SHOW GRANTS TO ROLE STAGE_R    (empty, 0.12s)
[garrett:ACCOUNTADMIN] > SHOW GRANTS TO ROLE CICD_R    (empty, 0.12s)
[garrett:ACCOUNTADMIN] > SHOW GRANTS TO ROLE RAW_R    (empty, 0.11s)
[garrett:ACCOUNTADMIN] > SHOW GRANTS TO ROLE RAW_DEV_R    (empty, 0.13s)
[garrett:ACCOUNTADMIN] > SHOW FUTURE GRANTS TO ROLE PROD_R    (err 2003, 0.17s)
[garrett:ACCOUNTADMIN] > SHOW FUTURE GRANTS TO ROLE PROD_R    (err 2003, 0.12s)
[garrett:ACCOUNTADMIN] > SHOW FUTURE GRANTS TO ROLE DEV_R    (err 2003, 0.27s)
[garrett:ACCOUNTADMIN] > SHOW FUTURE GRANTS TO ROLE DEV_R    (err 2003, 0.12s)
[garrett:ACCOUNTADMIN] > SHOW FUTURE GRANTS TO ROLE STAGE_R    (err 2003, 0.11s)
[garrett:ACCOUNTADMIN] > SHOW FUTURE GRANTS TO ROLE STAGE_R    (err 2003, 0.17s)
[garrett:ACCOUNTADMIN] > SHOW FUTURE GRANTS TO ROLE CICD_R    (err 2003, 0.13s)
[garrett:ACCOUNTADMIN] > SHOW FUTURE GRANTS TO ROLE CICD_R    (err 2003, 0.13s)
[garrett:ACCOUNTADMIN] > SHOW FUTURE GRANTS TO ROLE RAW_R    (err 2003, 0.18s)
[garrett:ACCOUNTADMIN] > SHOW FUTURE GRANTS TO ROLE RAW_R    (err 2003, 0.12s)
[garrett:ACCOUNTADMIN] > SHOW FUTURE GRANTS TO ROLE RAW_DEV_R    (err 2003, 0.17s)
[garrett:ACCOUNTADMIN] > SHOW FUTURE GRANTS TO ROLE RAW_DEV_R    (err 2003, 0.22s)
[garrett:ACCOUNTADMIN] > SHOW DATABASES IN ACCOUNT    (2 rows, 0.15s)
[garrett:ACCOUNTADMIN] > SHOW SCHEMAS IN ACCOUNT    (27 rows, 0.35s)
[garrett:ACCOUNTADMIN] > SHOW DATABASE ROLES IN DATABASE PROD    (err 2003, 0.15s)
[garrett:ACCOUNTADMIN] > SHOW DATABASE ROLES IN DATABASE PROD    (err 2003, 0.11s)
[garrett:ACCOUNTADMIN] > SHOW DATABASE ROLES IN DATABASE DEV    (err 2003, 0.15s)
[garrett:ACCOUNTADMIN] > SHOW DATABASE ROLES IN DATABASE DEV    (err 2003, 0.12s)
[garrett:ACCOUNTADMIN] > SHOW DATABASE ROLES IN DATABASE STAGE    (err 2003, 0.14s)
[garrett:ACCOUNTADMIN] > SHOW DATABASE ROLES IN DATABASE STAGE    (err 2003, 0.11s)
[garrett:ACCOUNTADMIN] > SHOW DATABASE ROLES IN DATABASE RAW    (err 2003, 0.12s)
[garrett:ACCOUNTADMIN] > SHOW DATABASE ROLES IN DATABASE RAW    (err 2003, 0.11s)
[garrett:ACCOUNTADMIN] > SHOW DATABASE ROLES IN DATABASE RAW_DEV    (err 2003, 0.13s)
[garrett:ACCOUNTADMIN] > SHOW DATABASE ROLES IN DATABASE RAW_DEV    (err 2003, 0.11s)
[garrett:ACCOUNTADMIN] > SHOW DATABASE ROLES IN DATABASE CICD    (err 2003, 0.12s)
[garrett:ACCOUNTADMIN] > SHOW DATABASE ROLES IN DATABASE CICD    (err 2003, 0.12s)
[garrett:ACCOUNTADMIN] > SHOW GRANTS OF ROLE RAW_R    (err 2003, 0.12s)
[garrett:ACCOUNTADMIN] > SHOW GRANTS OF ROLE RAW_W    (err 2003, 0.12s)
[garrett:ACCOUNTADMIN] > SHOW GRANTS OF ROLE RAW_DEV_R    (err 2003, 0.13s)
[garrett:ACCOUNTADMIN] > SHOW GRANTS OF ROLE RAW_DEV_W    (err 2003, 0.15s)
[garrett:ACCOUNTADMIN] > SHOW GRANTS OF ROLE DEV_R    (err 2003, 0.15s)
[garrett:ACCOUNTADMIN] > SHOW GRANTS OF ROLE DEV_W    (err 2003, 0.11s)
[garrett:ACCOUNTADMIN] > SHOW GRANTS OF ROLE PROD_R    (err 2003, 0.11s)
[garrett:ACCOUNTADMIN] > SHOW GRANTS OF ROLE PROD_W    (err 2003, 0.11s)
[garrett:ACCOUNTADMIN] > SHOW GRANTS OF ROLE STAGE_R    (err 2003, 0.13s)
[garrett:ACCOUNTADMIN] > SHOW GRANTS OF ROLE STAGE_W    (err 2003, 0.12s)
[garrett:ACCOUNTADMIN] > SHOW GRANTS OF ROLE CICD_R    (err 2003, 0.11s)
[garrett:ACCOUNTADMIN] > SHOW GRANTS OF ROLE CICD_W    (err 2003, 0.16s)
[garrett:ACCOUNTADMIN] > SHOW GRANTS OF ROLE DEVELOPER    (err 2003, 0.12s)
[garrett:ACCOUNTADMIN] > SHOW GRANTS OF ROLE SECURITYADMIN    (1 rows, 0.14s)
[garrett:ACCOUNTADMIN] > SHOW GRANTS OF ROLE USERADMIN    (1 rows, 0.21s)
[garrett:ACCOUNTADMIN] > SHOW GRANTS OF ROLE ACCOUNTADMIN    (1 rows, 0.14s)
[garrett:ACCOUNTADMIN] > SHOW GRANTS OF ROLE SYSADMIN    (1 rows, 0.13s)
[garrett:ACCOUNTADMIN] > SHOW USERS IN ACCOUNT    (2 rows, 0.14s)```


```titan.exceptions.MissingResourceException: Resource urn::<ROLE NAME> required by <ROLE NAME>?priv=ALL&on=database/PROD not found or failed to fetch```

Maybe there's an issue with my yml file?

I can make the dbs quickly enough, but expected them to be created for me.

@GJMcClintock
Copy link

GJMcClintock commented Nov 14, 2024 •
edited
Loading

Clarifying on this, my yml is setup:

  • warehouses
  • users
  • databases
  • database_roles
  • roles
  • role_grants
  • grants
  • future_grants

edit: making all the database roles regular roles seems to have worked.

@teej
Copy link
Collaborator

teej commented Nov 14, 2024

@GJMcClintock can you confirm which version of Titan you're on?

@GJMcClintock
Copy link

@teej 0.10.13 - just installed today

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug Something isn't working
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@teej @dsmdavid @GJMcClintock