Information |
Full Login Name | |
Default Database | icsa |
Default Language | us_english |
Password Status | Current |
Last Password Change | 07/19/1999 |
Logged In | Yes |
Is Account Locked | No |
Database Access |
Database Name | User Name | Alias User Name |
browseprod | dbo | |
controls | dbo | |
hpdp | dbo | |
icsa | dbo | |
icsa_tmp | dbo | |
master | isopma | |
publications | dbo | |
speval | dbo | |
sybsystemprocs | isopma | |
udf | dbo |
Role Information |
Role Name | Default Role |
Accounting Information |
CPU Time | 57071069 | I/O TIME | 327560513 | ACCOUNTING INTERVAL DATE | 07/19/1999 |
DDL |
USE master
go
EXEC sp_addlogin 'isopma','PASSWORD','icsa','us_english',null,null,null,null
go
USE browseprod
go
EXEC sp_changedbowner 'isopma'
go
USE controls
go
EXEC sp_changedbowner 'isopma'
go
USE hpdp
go
EXEC sp_changedbowner 'isopma'
go
USE icsa
go
EXEC sp_changedbowner 'isopma'
go
USE icsa_tmp
go
EXEC sp_changedbowner 'isopma'
go
USE master
go
EXEC sp_adduser 'isopma','isopma','public'
go
USE publications
go
EXEC sp_changedbowner 'isopma'
go
USE speval
go
EXEC sp_changedbowner 'isopma'
go
USE sybsystemprocs
go
EXEC sp_adduser 'isopma','isopma','public'
go
USE udf
go
EXEC sp_changedbowner 'isopma'
go