Tables [dbo].[ldaptemp]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count0
Created11:07:20 AM Wednesday, March 07, 2007
Last Modified11:09:40 AM Wednesday, March 07, 2007
Columns
NameData TypeMax Length (Bytes)Allow NullsDefault
npmfnvarchar(32)64
No
(' ')
nreportstonvarchar(128)256
No
(' ')
Permissions
TypeActionOwning Principal
GrantDeleteaiadmin
GrantInsertaiadmin
GrantSelectaiadmin
GrantUpdateaiadmin
SQL Script
CREATE TABLE [dbo].[ldaptemp]
(
[npmf] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ldaptemp__npmf__68C86C1B] DEFAULT (' '),
[nreportsto] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ldaptemp__nrepor__69BC9054] DEFAULT (' ')
) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ldaptemp] TO [aiadmin]
GRANT INSERT ON  [dbo].[ldaptemp] TO [aiadmin]
GRANT DELETE ON  [dbo].[ldaptemp] TO [aiadmin]
GRANT UPDATE ON  [dbo].[ldaptemp] TO [aiadmin]
GO
Uses