[dbo].[tng_dbserver_connectinfo]

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Row Count	262
Created	11:07:34 AM Wednesday, March 07, 2007
Last Modified	11:09:45 AM Wednesday, March 07, 2007

Property

Value

Collation

SQL_Latin1_General_CP1_CS_AS

Row Count

262

Created

11:07:34 AM Wednesday, March 07, 2007

Last Modified

11:09:45 AM Wednesday, March 07, 2007

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key pk_key: client_pid\client_host_name\client_user\application_name$ $Indexes baseidx_tng_dbserver_connectinfo: client_pid\client_host_name\connection_id$ $Indexes x_tng_dbserver_connectinfo_key: client_pid\client_host_name\connection_id$	client_pid	int	4
$Cluster Primary Key pk_key: client_pid\client_host_name\client_user\application_name$ $Indexes baseidx_tng_dbserver_connectinfo: client_pid\client_host_name\connection_id$ $Indexes x_tng_dbserver_connectinfo_key: client_pid\client_host_name\connection_id$	client_host_name	varchar(32)	32
$Cluster Primary Key pk_key: client_pid\client_host_name\client_user\application_name$	client_user	varchar(32)	32
$Cluster Primary Key pk_key: client_pid\client_host_name\client_user\application_name$	application_name	varchar(255)	255
	description	varchar(255)	255
	timestamp	datetime	8
$Indexes baseidx_tng_dbserver_connectinfo: client_pid\client_host_name\connection_id$ $Indexes x_tng_dbserver_connectinfo_key: client_pid\client_host_name\connection_id$	connection_id	int	4
	thread_id	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key pk_key: client_pid\client_host_name\client_user\application_name$ $Indexes baseidx_tng_dbserver_connectinfo: client_pid\client_host_name\connection_id$ $Indexes x_tng_dbserver_connectinfo_key: client_pid\client_host_name\connection_id$

client_pid

int

client_host_name

varchar(32)

$Cluster Primary Key pk_key: client_pid\client_host_name\client_user\application_name$

client_user

varchar(32)

$Cluster Primary Key pk_key: client_pid\client_host_name\client_user\application_name$

application_name

varchar(255)

255

description

varchar(255)

255

timestamp

datetime

$Indexes baseidx_tng_dbserver_connectinfo: client_pid\client_host_name\connection_id$ $Indexes x_tng_dbserver_connectinfo_key: client_pid\client_host_name\connection_id$

connection_id

int

thread_id

int

	Name	Columns
$Cluster Primary Key pk_key: client_pid\client_host_name\client_user\application_name$	pk_key	client_pid, client_host_name, client_user, application_name
	baseidx_tng_dbserver_connectinfo	client_pid, client_host_name, connection_id
	x_tng_dbserver_connectinfo_key	client_pid, client_host_name, connection_id

Name

Columns

Unique

$Cluster Primary Key pk_key: client_pid\client_host_name\client_user\application_name$

pk_key

client_pid, client_host_name, client_user, application_name

baseidx_tng_dbserver_connectinfo

client_pid, client_host_name, connection_id

x_tng_dbserver_connectinfo_key

client_pid, client_host_name, connection_id

Type	Action	Owning Principal
Grant	Delete	uniadmin
Grant	Insert	uniadmin
Grant	Delete	uniuser
Grant	Insert	uniuser
Grant	Delete	wvadmin
Grant	Insert	wvadmin
Grant	Delete	wvuser
Grant	Insert	wvuser
Grant	Select	uniadmin
Grant	Update	uniadmin
Grant	Select	uniuser
Grant	Update	uniuser
Grant	Select	wvadmin
Grant	Update	wvadmin
Grant	Select	wvuser
Grant	Update	wvuser

Type

Action

Owning Principal

Grant

Delete

uniadmin

Grant

Insert

uniadmin

Grant

Delete

uniuser

Grant

Insert

uniuser

Grant

Delete

wvadmin

Grant

Insert

wvadmin

Grant

Delete

wvuser

Grant

Insert

wvuser

Grant

Select

uniadmin

Grant

Update

uniadmin

Grant

Select

uniuser

Grant

Update

uniuser

Grant

Select

wvadmin

Grant

Update

wvadmin

Grant

Select

wvuser

Grant

Update

wvuser

SQL Script

CREATE TABLE [dbo].[tng_dbserver_connectinfo]
(
[client_pid] [int] NOT NULL,
[client_host_name] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[client_user] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[application_name] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[timestamp] [datetime] NOT NULL,
[connection_id] [int] NULL,
[thread_id] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[tng_dbserver_connectinfo] ADD CONSTRAINT [pk_key] PRIMARY KEY CLUSTERED ([client_pid], [client_host_name], [client_user], [application_name]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_tng_dbserver_connectinfo] ON [dbo].[tng_dbserver_connectinfo] ([client_pid], [client_host_name], [connection_id]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [x_tng_dbserver_connectinfo_key] ON [dbo].[tng_dbserver_connectinfo] ([client_pid], [client_host_name], [connection_id]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[tng_dbserver_connectinfo] TO [uniadmin]
GRANT INSERT ON  [dbo].[tng_dbserver_connectinfo] TO [uniadmin]
GRANT DELETE ON  [dbo].[tng_dbserver_connectinfo] TO [uniadmin]
GRANT UPDATE ON  [dbo].[tng_dbserver_connectinfo] TO [uniadmin]
GRANT SELECT ON  [dbo].[tng_dbserver_connectinfo] TO [uniuser]
GRANT INSERT ON  [dbo].[tng_dbserver_connectinfo] TO [uniuser]
GRANT DELETE ON  [dbo].[tng_dbserver_connectinfo] TO [uniuser]
GRANT UPDATE ON  [dbo].[tng_dbserver_connectinfo] TO [uniuser]
GRANT SELECT ON  [dbo].[tng_dbserver_connectinfo] TO [wvadmin]
GRANT INSERT ON  [dbo].[tng_dbserver_connectinfo] TO [wvadmin]
GRANT DELETE ON  [dbo].[tng_dbserver_connectinfo] TO [wvadmin]
GRANT UPDATE ON  [dbo].[tng_dbserver_connectinfo] TO [wvadmin]
GRANT SELECT ON  [dbo].[tng_dbserver_connectinfo] TO [wvuser]
GRANT INSERT ON  [dbo].[tng_dbserver_connectinfo] TO [wvuser]
GRANT DELETE ON  [dbo].[tng_dbserver_connectinfo] TO [wvuser]
GRANT UPDATE ON  [dbo].[tng_dbserver_connectinfo] TO [wvuser]
GO