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