devguest

 

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 11/24/2003
Logged In No
Is Account Locked No

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

Role Information
Role Name Default Role

Accounting Information
CPU Time 370672 I/O TIME 3865293 ACCOUNTING INTERVAL DATE 11/24/2003

DDL

USE master
go
EXEC sp_addlogin 'devguest','PASSWORD','icsa','us_english',null,null,6,null
go
USE browseprod
go
EXEC sp_addalias 'devguest','guest'
go
USE controls
go
EXEC sp_addalias 'devguest','guest'
go
USE hpdp
go
EXEC sp_addalias 'devguest','guest'
go
USE icsa
go
EXEC sp_addalias 'devguest','guest'
go
USE icsa_tmp
go
EXEC sp_addalias 'devguest','guest'
go
USE publications
go
EXEC sp_addalias 'devguest','guest'
go
USE speval
go
EXEC sp_addalias 'devguest','guest'
go