sqluser

 

Object Type

Login

Datasource

IPMA_1

Database

N/A

 

Information
Full Login Name
Default Database icsa
Default Language us_english
Password Status Current
Last Password Change 07/19/1999
Logged In No
Is Account Locked No

Database Access
Database Name User Name Alias User Name
browseprod sqluser
controls guest
hpdp sqluser
icsa sqluser
publications sqluser
speval sqluser

Role Information
Role Name Default Role

Accounting Information
CPU Time 52046 I/O TIME 68833 ACCOUNTING INTERVAL DATE 07/19/1999

DDL

USE master
go
EXEC sp_addlogin 'sqluser','PASSWORD','icsa','us_english',null,null,null,null
go
USE browseprod
go
EXEC sp_adduser 'sqluser','sqluser','public'
go
USE controls
go
EXEC sp_addalias 'sqluser','guest'
go
USE hpdp
go
EXEC sp_adduser 'sqluser','sqluser','public'
go
USE icsa
go
EXEC sp_adduser 'sqluser','sqluser','public'
go
USE publications
go
EXEC sp_adduser 'sqluser','sqluser','public'
go
USE speval
go
EXEC sp_adduser 'sqluser','sqluser','public'
go