This will be very useful when you want to know who all are having access to the database.
Execute the below stored procedure,
sp_helpuser
out put of this stored procedure will be
UserName, GroupName, LoginName, DefDBName, UserID, SID
Tuesday, May 18, 2010
SQL-Query-to-list-all-Users-or-Login-Names--database
Views
0 comments:
Post a Comment