Kbase 16428: What userid is available in your Sybase10 database?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
What userid is available in your Sybase10 database?
To find out what users are available for use in a Sybase10 database;
you need to look in the syslogins table in Master database.
To check if you are login to Master database:
1> select db_name()
2> go
------------------------------
s10_4
**Note this show that you are not login to Master database
To change your current database to Master database:
1> use master
2> go
To display the users or logins already created in syslogins table:
1> select suid, status, dbname, name, language, pwdate
2> from syslogins
3> go
suid status dbname name
language pwdate
------ ------ ------------------------------ ------------------------
------
------------------------------ --------------------------
1 1 master sa
NULL Sep 5 1995 9:46PM
2 0 master probe
NULL Sep 20 1996 10:52AM
4 0 master xxxxx
NULL Nov 5 1996 9:26AM
5 0 master s10_4
NULL Nov 5 1996 2:54PM
(4 rows affected)
Progress Software Technical Support Note # 16428