Monday, March 12, 2012

How to find out Usersinfo using JDBC Connection to SQL Server

Hi..
I want to find out the List of users created in SQL Server.
Im using type 4 Driver to Connect SQL Server.
Regards
maruthi.List of active users, users for a database or logins for the sql server ?|||select * from master.dbo.syslogins
select * from master.dbo.sysxlogins
select * from your_database.dbo.sysusers|||Thanks

the problem is solved.

No comments:

Post a Comment