isopma

 

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 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