[
https://issues.apache.org/jira/browse/SENTRY-1445?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Bhooshan Mogal updated SENTRY-1445:
-----------------------------------
Description: In the DDLs for the Apache Sentry Policy Store, it seems like
role names can be 128 characters wide, as at [role
name|https://github.com/apache/sentry/blob/branch-1.7.0/sentry-provider/sentry-provider-db/src/main/resources/sentry-postgres-1.7.0.sql#L41].
However, the columns in the
[SENTRY_GM_PRIVILEGE|https://github.com/apache/sentry/blob/branch-1.7.0/sentry-provider/sentry-provider-db/src/main/resources/sentry-postgres-1.7.0.sql#L128]
table are only 64 characters wide. These should be made consistent (the
privileges columns should be made wider), since creating a long role name seems
to succeed, but granting privileges on it fails. (was: In the DDLs for the
Apache Sentry Policy Store, it seems like role names can be 128 characters
wide, as at [role
name|https://github.com/apache/sentry/blob/branch-1.7.0/sentry-provider/sentry-provider-db/src/main/resources/sentry-postgres-1.7.0.sql#L41].
However, the columns in the
[SENTRY_GM_PRIVILEGE|https://github.com/apache/sentry/blob/branch-1.7.0/sentry-provider/sentry-provider-db/src/main/resources/sentry-postgres-1.7.0.sql#L128]
table are only 64 characters wide. These should be made consistent, since
creating a long role name seems to succeed, but granting privileges on it
fails.)
> Inconsistent column widths in the policy store
> ----------------------------------------------
>
> Key: SENTRY-1445
> URL: https://issues.apache.org/jira/browse/SENTRY-1445
> Project: Sentry
> Issue Type: Bug
> Components: Sentry
> Affects Versions: 1.7.0
> Reporter: Bhooshan Mogal
>
> In the DDLs for the Apache Sentry Policy Store, it seems like role names can
> be 128 characters wide, as at [role
> name|https://github.com/apache/sentry/blob/branch-1.7.0/sentry-provider/sentry-provider-db/src/main/resources/sentry-postgres-1.7.0.sql#L41].
> However, the columns in the
> [SENTRY_GM_PRIVILEGE|https://github.com/apache/sentry/blob/branch-1.7.0/sentry-provider/sentry-provider-db/src/main/resources/sentry-postgres-1.7.0.sql#L128]
> table are only 64 characters wide. These should be made consistent (the
> privileges columns should be made wider), since creating a long role name
> seems to succeed, but granting privileges on it fails.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
