Dismiss
InnovationQ will be updated on Sunday, Oct. 22, from 10am ET - noon. You may experience brief service interruptions during that time.
Browse Prior Art Database

DATABASE AGENCY PARTITIONING USING SECURITY GROUPS

IP.com Disclosure Number: IPCOM000007459D
Original Publication Date: 1995-Jul-01
Included in the Prior Art Database: 2002-Mar-28
Document File: 2 page(s) / 72K

Publishing Venue

Motorola

Related People

Stan Dorcey: AUTHOR [+4]

Abstract

Currently in trunked radio systems, any user who can login to the management terminal may view any information within the database. As radio sys- tems become increasingly large, complex and expen- sive, it is likely that several groups, or agencies, will share a trunked radio system. However, these agen- cies may wish to protect their portion ofthe database from access by other users of the system. By implementing an Agency Partitioning scheme, agen- cies see only the elements of the database that they have access to.

This text was extracted from a PDF file.
At least one non-text object (such as an image or picture) has been suppressed.
This is the abbreviated version, containing approximately 59% of the total text.

Page 1 of 2

MOlVROLA Technical Developments

DATABASE AGENCY PARTITIONING USING SECURITY GROUPS

by Stan Dorcey, Anne Marie Johlie, Larry Peterson and Tim Sherburne

BACKGROUND

  Currently in trunked radio systems, any user who can login to the management terminal may view any information within the database. As radio sys- tems become increasingly large, complex and expen- sive, it is likely that several groups, or agencies, will share a trunked radio system. However, these agen- cies may wish to protect their portion ofthe database from access by other users of the system. By implementing an Agency Partitioning scheme, agen- cies see only the elements of the database that they have access to.

  Using the security systems that are implemented by relational database packages, users may only be restricted access to database tables. However, a sin- gle row of a database table is considered to be a 'managed object' within the radio system database and is therefore the desired partition unit.

SOLUTION

In order to implement a database partitioning

scheme within a radio system, a new logical object called a security group is defined. A security group is simply a container object for other objects within the radio system database. Every managed object within the database must be associated with a secu- rity group.

  In order to login to the radio system manage- ment terminal, a user account must exist. Within the definition ofa user account are a list ofthe secu- rity groups to which the use...