/*****************************************************************************
*
* Filename         - $Workfile:   user_group_v1.sql  $
*
*                     Name              Date      Version     CR Number
* Author           - See revision history below.
* Last Update      - See revision history below.
*
* Project Name     - TAGTRAK(Oracle Database)
*
* Source Code
* Identifier       - 0/3/300/8010/112
*
* Design Spec
* Section          - 
*
* Contents         - Live Schema View
*
* Language         - Oracle SQL*Plus script
*
* Classification   - Commercial In Confidence
*
*          (c) Ultra Electronics Limited, 1997
*
*****************************************************************************/
/****************************************************************************
* @(#)$Workfile:   user_group_v1.sql  $  $Revision:   1.3  $
*
* Revision History
*
* Note that user tagtrak is many users. For these users the user
* name is entered as the last line in the change description.
*
* $Log:   /pvcsarch/db_ora/db/source/live/views/user_group_v1.svl  $
* 
*    Rev 1.3   21 Jun 2001 15:38:14   tagtrak
* OR:
* CR:
* Re-baseline version 4.0.0 to include patches.
* 
*    Rev 1.2   16 Dec 1998 11:35:38   tagtrak
* OR: 12412 12200
* CR: 12412
* REV:
* Extent user_group table and associated views, procedures
* and functions, to handle more than 50 privilege codes.
* This was extended to 62, to allow upper and lower case alphabet
* plus 10 digits.
* -------------
* Andrew Walker
* -------------
* (branch ATS revision copied to trunk.)
* Andrew Walker
* 
*    Rev 1.1.1.0   19 Nov 1998 16:15:28   tagtrak
* OR: 12412 12200
* CR: 12412
* REV:
* Extent user_group table and associated views, procedures
* and functions, to handle more than 50 privilege codes.
* This was extended to 62, to allow upper and lower case alphabet
* plus 10 digits.
* -------------
* Andrew Walker
* 
*    Rev 1.1   02 Apr 1998 19:48:24   tagtrak
* OR:
* CR:
* REV:
* Initial Issue
* See label for concession
* 
*    Rev 1.0   22 Oct 1997 16:51:16   tagtrak
* OR:
* CR:
* REV:
* Initial check-in
*
****************************************************************************/
PROMPT Creating view user_group_v1

CREATE OR REPLACE FORCE VIEW user_group_v1 (
	group_name,
	priv1,
	priv2,
	priv3,
	priv4,
	priv5,
	priv6,
	priv7,
	priv8,
	priv9,
	priv10,
	priv11,
	priv12,
	priv13,
	priv14,
	priv15,
	priv16,
	priv17,
	priv18,
	priv19,
	priv20,
	priv21,
	priv22,
	priv23,
	priv24,
	priv25,
	priv26,
	priv27,
	priv28,
	priv29,
	priv30,
	priv31,
	priv32,
	priv33,
	priv34,
	priv35,
	priv36,
	priv37,
	priv38,
	priv39,
	priv40,
	priv41,
	priv42,
	priv43,
	priv44,
	priv45,
	priv46,
	priv47,
	priv48,
	priv49,
	priv50, 
	priv51,
	priv52,
	priv53,
	priv54,
	priv55,
	priv56,
	priv57,
	priv58,
	priv59,
	priv60,
	priv61,
	priv62,
	last_user  
) as
select
  group_name,
  priv1,
  priv2,
  priv3,
  priv4,
  priv5,
  priv6,
  priv7,
  priv8,
  priv9,
  priv10,
  priv11,
  priv12,
  priv13,
  priv14,
  priv15,
  priv16,
  priv17,
  priv18,
  priv19,
  priv20,
  priv21,
  priv22,
  priv23,
  priv24,
  priv25,
  priv26,
  priv27,
  priv28,
  priv29,
  priv30,
  priv31,
  priv32,
  priv33,
  priv34,
  priv35,
  priv36,
  priv37,
  priv38,
  priv39,
  priv40,
  priv41,
  priv42,
  priv43,
  priv44,
  priv45,
  priv46,
  priv47,
  priv48,
	priv49,
  priv50,
  priv51,
  priv52,
  priv53,
  priv54,
  priv55,
  priv56,
  priv57,
  priv58,
  priv59,
  priv60,
  priv61,
  priv62,
  last_user
from
  user_group;

