Skip to content

Add granted roles to default roles when generating solution for mission roles #6

@PhilippSalvisberg

Description

@PhilippSalvisberg

If select_catalog_role is not found in session_roles the following solution is generated:

GRANT SELECT_CATALOG_ROLE TO «conn.metaData.userName»;

This is ok, but to ensure the resolution works also when the role is not defaulted, the following additional statement should be generated as well:

ALTER USER «conn.metaData.userName» DEFAULT ROLE select_catalog_role, ...;

the , ... represents the list of existing roles.

Metadata

Metadata

Labels

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions