Grant on Native Applications: Must grant access to tags and policies

Attention

This behavior change is in the 2023_07 bundle.

For the current status of the bundle, refer to Bundle History.

Using tags and policies on a reference database requires the REFERENCE_USAGE privilege on the reference database.

Before the change:

If a database containing only tag or policy dependencies is used by objects shared with an application package, the provider is not required to explicitly grant the REFERENCE_USAGE privilege on the databases to the application package.

After the change:

If a database containing only tag or policy dependencies is used indirectly by objects shared with an application package, the provider must explicitly grant the REFERENCE_USAGE privilege on the databases to the application package.

To grant the REFERENCE_USAGE privilege on a database to the application package, run the following command:

GRANT REFERENCE_USAGE ON DATABASE <name> TO SHARE IN APPLICATION PACKAGE <app_package>
Copy

Where:

name

Specifies the identifier of the referenced database that contains a tag or policy.

app_package

Specifies the identifier for the application package to which the REFERENCE_USAGE privilege is being granted.

Ref: 1274