Database	Table	Application	Created	Links
master	syslogins		31 Aug 14	Joins Schema ColumnUsage Queries Dependencies

1     create table syslogins(-- 0 Rows, Data: 0 B, Index: 0 B
2         suid int not null,
3         status smallint not null,
4         accdate datetime not null,
5         totcpu int not null,
6         totio int not null,
7         spacelimit int not null,
8         timelimit int not null,
9         resultlimit int not null,
10        dbname sysname null,
11        name sysname not null,
12        password varbinary(128) null,
13        language varchar(30) null,
14        pwdate datetimn null,
15        audflags int null,
16        fullname varchar(30) null,
17        srvname varchar(30) null,
18        logincount smallint null,
19        procid int null,
20        lastlogindate datetimn null,
21        crdate datetimn null,
22        locksuid int null,
23        lockreason int null,
24        lockdate datetimn null,
25        lpid int null,
26        crsuid int null
27    )
28    
29    create unique clustered index csyslogins on syslogins(-- 2 KB refcount: 64
30        suid
31    )
32    create unique index ncsyslogins on syslogins(-- 2 KB refcount: 87
33        name
34    )
35    
36    alter table syslogins lock datarows
37    
38    Grant Select on syslogins to public
39    Grant Select on syslogins to sso_role
40    

SCHEMA

DEPENDENCIES

READERS AND WRITERS read by proc sybsystemprocs..sp_showcontrolinfo   read by proc sybsystemprocs..sp_activeroles   read by proc sybsystemprocs..sp_helpuser   read by proc sybsystemprocs..sp_password      called by proc sybsystemprocs..sp_addlogin   read by proc sybsystemprocs..sp_multdb_show      called by proc sybsystemprocs..sp_tempdb   written by proc sybsystemprocs..sp_update_authmech_value   read by proc sybsystemprocs..sp_displaylogin   read by proc sybsystemprocs..sp_drop_resource_limit   read by proc sybsystemprocs..sp_reportstats      called by proc sybsystemprocs..sp_clearstats   read by proc sybsystemprocs..sp_unbindexeclass   read by proc sybsystemprocs..sp_addremotelogin   read by proc sybsystemprocs..sp_encryption      called by proc sybsystemprocs..sp_downgrade   read_written by proc sybsystemprocs..sp_clearstats   read by proc sybsystemprocs..sp_gen_login_id      called by proc sybsystemprocs..sp_addlogin   read by proc sybsystemprocs..sp_securityprofile   read by proc sybsystemprocs..sp_checkreswords   read by proc sybsystemprocs..sp_maplogin   read by proc sybsystemprocs..sp_help_resource_limit   read by proc sybsystemprocs..sp_helpexternlogin   read by proc sybsystemprocs..sp_add_resource_limit   read by proc sybsystemprocs..sp_showpsexe   written by proc sybsystemprocs..sp_renamedb   read_written by proc sybsystemprocs..sp_defaultlanguage      called by proc sybsystemprocs..sp_modifylogin   read by proc sybsystemprocs..sp_displayroles   read by proc sybsystemprocs..sp_adduser   read by proc sybsystemprocs..sp_bindexeclass   read_written by proc sybsystemprocs..sp_addlogin   read by proc sybsystemprocs..sp_aux_encr_verify_downgrade   read by proc sybsystemprocs..sp_changedbowner   read by proc sybsystemprocs..sp_checknames   read by proc sybsystemprocs..sp_multdb_unbind      called by proc sybsystemprocs..sp_tempdb   read_written by proc sybsystemprocs..sp_locklogin      called by proc sybsystemprocs..sp_addlogin      called by proc sybsystemprocs..sp_droplogin   read_written by proc sybsystemprocs..sp_autoconnect   read_written by proc sybsystemprocs..sp_modifylogin   read by proc sybsystemprocs..sp_multdb_bind      called by proc sybsystemprocs..sp_tempdb   read_written by proc sybsystemprocs..sp_droplogin   read by proc sybsystemprocs..sp_addalias   read by proc sybsystemprocs..sp_passwordpolicy      called by proc sybsystemprocs..sp_downgrade   read by proc sybsystemprocs..sp_modify_resource_limit   read_written by proc sybsystemprocs..sp_defaultdb      called by proc sybsystemprocs..sp_modifylogin