[ 
https://issues.apache.org/jira/browse/AMBARI-13865?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Robert Levas updated AMBARI-13865:
----------------------------------
    Description: 
Add authorizations to permissions so that the definition of a permission (or 
role) is explicit.

A new table needs to be created to store the _authorizations_:
{code}
TABLE roleauthorization (
  authorization_id VARCHAR(100) NOT NULL,
  authorization_name VARCHAR(255) NOT NULL,
  resource_type_id INTEGER NOT NULL,
  PRIMARY KEY(authorization_id)
)
{code}

A new table needs to be added to map _authorizations_ to _permissions_
{code}
TABLE permission_roleauthorization (
  permission_id BIGINT NOT NULL,
  authorization_id VARCHAR(100) NOT NULL,
  PRIMARY KEY(permission_id, authorization_id)
);
{code}

A new Entity needs to be created to hold the authorization record data 
({{org.apache.ambari.server.orm.entities.AuthorizationEntity}}).

The existing PermissionEntity 
{{org.apache.ambari.server.orm.entities.PermissionEntity}} needs to be updated 
to include AuthorizationEntities.


  was:
Add authorizations to permissions so that the definition of a permission (or 
role) is explicit.

A new table needs to be created to store the _authorizations_:
{code}
TABLE roleauthorization (
  authorization_id VARCHAR(100) NOT NULL,
  authorization_name VARCHAR(255) NOT NULL,
  PRIMARY KEY(authorization_id)
)
{code}

A new table needs to be added to map _authorizations_ to _permissions_
{code}
TABLE permission_roleauthorization (
  permission_id BIGINT NOT NULL,
  authorization_id VARCHAR(100) NOT NULL,
  PRIMARY KEY(permission_id, authorization_id)
);
{code}

A new Entity needs to be created to hold the authorization record data 
({{org.apache.ambari.server.orm.entities.AuthorizationEntity}}).

The existing PermissionEntity 
{{org.apache.ambari.server.orm.entities.PermissionEntity}} needs to be updated 
to include AuthorizationEntities.



> Add authorization resources to permission resources
> ---------------------------------------------------
>
>                 Key: AMBARI-13865
>                 URL: https://issues.apache.org/jira/browse/AMBARI-13865
>             Project: Ambari
>          Issue Type: Task
>            Reporter: Robert Levas
>            Assignee: Robert Levas
>              Labels: rbac
>
> Add authorizations to permissions so that the definition of a permission (or 
> role) is explicit.
> A new table needs to be created to store the _authorizations_:
> {code}
> TABLE roleauthorization (
>   authorization_id VARCHAR(100) NOT NULL,
>   authorization_name VARCHAR(255) NOT NULL,
>   resource_type_id INTEGER NOT NULL,
>   PRIMARY KEY(authorization_id)
> )
> {code}
> A new table needs to be added to map _authorizations_ to _permissions_
> {code}
> TABLE permission_roleauthorization (
>   permission_id BIGINT NOT NULL,
>   authorization_id VARCHAR(100) NOT NULL,
>   PRIMARY KEY(permission_id, authorization_id)
> );
> {code}
> A new Entity needs to be created to hold the authorization record data 
> ({{org.apache.ambari.server.orm.entities.AuthorizationEntity}}).
> The existing PermissionEntity 
> {{org.apache.ambari.server.orm.entities.PermissionEntity}} needs to be 
> updated to include AuthorizationEntities.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to