sp_help
//登录用户
1> select name,dbname from syslogins
2> go
name dbname
------------------------------ ------------------------------
sa master
probe sybsystemdb
1> select name, uid, gid, suid from sysusers
2> go
name uid gid suid
------------------------------ ----------- ----------- -----------
public 0 0 -2
sa_role 16384 16384 -2
sso_role 16385 16385 -2
oper_role 16386 16386 -2
sybase_ts_role 16387 16387 -2
navigator_role 16388 16388 -2
replication_role 16389 16389 -2
guest 2 0 -1
dbo 1 0 1
probe 3 0 2
1> sp_helpuser
2> go
Users_name ID_in_db Group_name Login_name
----------------- ----------- ----------------- -----------------
dbo 1 public sa
guest 2 public NULL
probe 3 public probe
1> use master
2>go
//登录用户
1> select name,dbname from syslogins
2> go
name dbname
------------------------------ ------------------------------
sa master
probe sybsystemdb
1> select name, uid, gid, suid from sysusers
2> go
name uid gid suid
------------------------------ ----------- ----------- -----------
public 0 0 -2
sa_role 16384 16384 -2
sso_role 16385 16385 -2
oper_role 16386 16386 -2
sybase_ts_role 16387 16387 -2
navigator_role 16388 16388 -2
replication_role 16389 16389 -2
guest 2 0 -1
dbo 1 0 1
probe 3 0 2
1> sp_helpuser
2> go
Users_name ID_in_db Group_name Login_name
----------------- ----------- ----------------- -----------------
dbo 1 public sa
guest 2 public NULL
probe 3 public probe
1> use master
2>go
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/22661144/viewspace-1430700/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
