SQL Server schema
Hi,
How can i get the user names assigned to the Schema through (T-SQL)
Regards;
Rino
Software/Hardware used:
sql server
Software/Hardware used:
sql server
ASKED:
May 24, 2010 10:51 AM
UPDATED:
May 25, 2010 4:18 AM
Answer Wiki:
<pre>select * from sys.sysusers (nolock) or
select * from sys.database_principals (nolock)</pre>
This will get you the list of "named" users of the database.
<pre>select * from sys.server_principals (nolock)
where type_desc = 'WINDOWS_LOGIN'</pre>
This will get you the list of users authorized by their Windows authentications. (This is probably what you really want.)
To see all answers submitted to the Answer Wiki: View Answer History.
Hi sir ,
Thnx for ur reply that was helpfull , but i want the users who are assigned to specific Shema name in a database.