Database Reference
In-Depth Information
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[tblUniquelabelMarking](
[KeyMappingID] [int] NOT NULL,
[CategoryID] [int] NOT NULL,
[MarkingRoleName] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_tblUniquelabelMarking] PRIMARY KEY
CLUSTERED
(
[KeyMappingID] ASC,
[CategoryID] ASC,
[MarkingRoleName] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,
IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_
PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
9.3.2 Source Code of the User Security Classification Levels
CREATE LOGIN [UUser] WITH PASSWORD = N'U', DEFAULT_
DATABASE = [master], DEFAULT_LANGUAGE = [us_
english], CHECK_EXPIRATION = OFF, CHECK_POLICY = OFF
GO
CREATE LOGIN [CUser] WITH PASSWORD = N'C', DEFAULT_
DATABASE = [master], DEFAULT_LANGUAGE = [us_
english], CHECK_EXPIRATION = OFF, CHECK_POLICY = OFF
GO
CREATE LOGIN [SUser] WITH PASSWORD = N'S', DEFAULT_
DATABASE = [master], DEFAULT_LANGUAGE = [us_
english], CHECK_EXPIRATION = OFF, CHECK_POLICY = OFF
GO
CREATE LOGIN [TSUser] WITH PASSWORD = N'TS', DEFAULT_
DATABASE = [master], DEFAULT_LANGUAGE = [us_
english], CHECK_EXPIRATION = OFF, CHECK_POLICY = OFF
GO
USE [MLSDB]
CREATE USER [UUser] FOR LOGIN [UUser] WITH DEFAULT_
SCHEMA = [dbo]
GO
USE [MLSDB]
CREATE USER [CUser] FOR LOGIN [CUser] WITH DEFAULT_
SCHEMA = [dbo]
GO
Search WWH ::




Custom Search