Enable ability to grant entities in Personal Databases to account roles (Pending)¶

Before the change:

Objects created in a Personal Database could be granted to users. For example:

CopyExpand

GRANT READ ON WORKSPACE USER$.PUBLIC.DEFAULT$ TO USER OTHER_USER;

Show lessSee more

Scroll to top

Granting privileges on Personal Database entities to account roles failed for any privilege, including CREATE. For example, Snowflake returned an error for the following statement:

CopyExpand

GRANT READ ON WORKSPACE USER$.PUBLIC.DEFAULT$ TO ROLE some_role;

Show lessSee more

Scroll to top

After the change:

When the 2026_03 behavior change bundle is enabled in your account, granting privileges on Personal Database entities to account roles succeeds for the same privileges you can grant to users, except CREATE. Grants of CREATE on Personal Database entities to roles continue to fail.

For example, the following statement succeeds when the bundle is enabled in your account:

CopyExpand

GRANT READ ON WORKSPACE USER$.PUBLIC.DEFAULT$ TO ROLE some_role;

Show lessSee more

Scroll to top

Granting other users or roles the ability to CREATE objects in a Personal Database remains blocked.

This change expands how you can share Personal Database objects within your account. Personal Databases support a frictionless experience for building tools such as UIs and dashboards; before this change, sharing those artifacts with others in the account effectively relied on direct user-to-user grants because grants to account roles were not allowed. User-to-user grants were already permitted, so this change does not introduce a new category of cross-user access; it adds role-based sharing so you can reach a wider audience through roles you already use elsewhere in the account. It does not expand data sharing or other cross-account sharing of PDB content.

This capability is generally available. Snowflake does not require additional customer readiness steps or diagnostics for this change.

Ref: 2290