>I am displaying a list of companies a user can select. but depending on the Windows user the application may or may not have acces to certain database withing Sqlserver so I need to restrict this list depending on the access of this windows user to the databases of the sqlserver.
>
>any idea of how would I know what are the databases the user has access to?
Is
sp_helplogins system stored procedure what you're looking for?
--sb--