fw group table privilege

Database Table

Name	fw_group_table_privilege
Prefix	gtp
Group Item	Group Table Privilege
Initial Build	2006.02

Overview

fw_group_table_privilege stores data about user groups and their privileges on the netFORUM database tables.

Columns

Name	Description	Datatype	Notes
gtp_key	Unique Key	av_key
gtp_grp_code	Group Code	nvarchar(50)
gtp_mdt_name	Table Name	nvarchar(128)
gtp_select	Select?	nvarchar(5)
gtp_insert	Insert?	nvarchar(5)
gtp_update	Update?	nvarchar(5)
gtp_delete	Delete?	nvarchar(5)
gtp_add_user	Add User	av_user
gtp_add_date	Add Date	av_date
gtp_change_user	Change User	av_user
gtp_change_date	Change Date	av_date
gtp_delete_flag	Delete Flag	av_delete_flag
gtp_entity_key	Entity Key	av_key

Parent Tables

Parent Table	Parent Key	Child Key	Join
fw_group	grp_code	gtp_grp_code	gtp_grp_code = grp_code
md_table	mdt_name	gtp_mdt_name	gtp_mdt_name = mdt_name