Browse Prior Art Database

Authorization Operator for Threaded

IP.com Disclosure Number: IPCOM000099273D
Original Publication Date: 1990-Jan-01
Included in the Prior Art Database: 2005-Mar-14
Document File: 1 page(s) / 42K

Publishing Venue

IBM

Related People

Boykin, JR: AUTHOR [+3]

Abstract

The authorization feature of Structured Query (SQL) protects database resources, such as rows and plans, against unauthorized access. Users, defined authorization IDs, gain database access in one of three privilege definition, object creation, or access plan Each access, whether implicit or explicit, is on the underlying concept of privilege. Privileges given or withdrawn via two SQL statements: GRANT and

This text was extracted from an ASCII text file.
This is the abbreviated version, containing approximately 79% of the total text.

Authorization Operator for Threaded

       The authorization feature of Structured Query (SQL)
protects database resources, such as rows and plans, against
unauthorized access.  Users, defined authorization IDs, gain database
access in one of three  privilege definition, object creation, or
access plan  Each access, whether implicit or explicit, is on the
underlying concept of privilege.  Privileges given or withdrawn via
two SQL statements:  GRANT and

      The context of the solution is the threaded code described in
other OS/2* Extended Edition  This architecture describes an Access
Section, is composed in part of data object and code threads. data
objects contain information about the data being on, and the threads
contain operators that direct execution upon the data.  Part of this
architecture is a to execute a GRANT or REVOKE statement.

      The current architecture is extended to include an AUT defined
as:
     AUT (Index, Length, AUT opcode structure)
     where
     Index  - type of privilege (GRANT or REVOKE)
     Length - length of the authorization structure
     AUT op code structure:
          privilege class (database, plan, index, or
          table)
          bit map of privileges to be granted or revoked
          object qualifier (length 8)
          object name length
          object name (maximum of 18 characters)
          number of authorizatio...