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