CREATE TABLE [dbo].[ap_nm_login]
(
[lkey] [int] NOT NULL,
[lnm] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[lnm_upcase] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[lekey] [int] NOT NULL,
[lprivileges] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_ap_nm_login] ON [dbo].[ap_nm_login] ([lkey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ap_nm_login_x1] ON [dbo].[ap_nm_login] ([lnm_upcase], [lekey]) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[ap_nm_login] TO [apnm_admin]
GRANT INSERT ON [dbo].[ap_nm_login] TO [apnm_admin]
GRANT DELETE ON [dbo].[ap_nm_login] TO [apnm_admin]
GRANT UPDATE ON [dbo].[ap_nm_login] TO [apnm_admin]
GRANT SELECT ON [dbo].[ap_nm_login] TO [apnm_user]
GO
[dbo].[ap_nm_login]
