Browse Prior Art Database

Extending the Grant SQL Statement to Allow the Use of the All Column Privilege Descriptor

IP.com Disclosure Number: IPCOM000108361D
Original Publication Date: 1992-May-01
Included in the Prior Art Database: 2005-Mar-22
Document File: 2 page(s) / 56K

Publishing Venue

IBM

Related People

Jacobs, DC: AUTHOR [+2]

Abstract

A method is described which will allow the user of the SQL GRANT statement to assign all column privileges to an authorization ID using one keyword.

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

Extending the Grant SQL Statement to Allow the Use of the All Column Privilege Descriptor

       A method is described which will allow the user of the
SQL GRANT statement to assign all column privileges to an
authorization ID using one keyword.

      The ISO (International Organization of Standard) architecture
for the Grant and Revoke statement in SQL (Structure Query Language)
supports  the granting  or revoking  of  table  privileges held by an
authorization ID. Some of  these  privileges  are  grantable  at  the
column level.  These privileges  currently include insert,  update,
and references.  There are plans to add these column privilege
levels to  SAA* (System  Application Architecture).

      OS/2*  Database  Manager's  implementation  of  column
privileges will follow the ISO standard.  What if the user desires to
grant all of the the column based privileges to a user?  In order to
grant insert, update,  and reference privileges  to  a  user,  the
following SQL statement would be required:
   GRANT UPDATE(column_one),
          REFERENCES(column_one),
          INSERT(column_one)
          ON dbase1
          TO authid

      As can be seen by this example,  in order to  GRANT every
available column  level  privilege  on  a  particular column  to a
user, the GRANT statement must explicitly contain all of the
following column  privilege descriptor keywords: UPDATE, REFER...