Re: SQL2000 UserPermissions for Database

how to list all the databases that Userx can login

Try:

EXEC sp_helplogins 'Userx'

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Arejan" <areejan2000@xxxxxxxxx> wrote in message news:1165249163.905889.70140@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Ok

how to list all the databases that Userx can login


.

Relevant Pages

  • users "name" different than "login name"
    ... I need to copy this database to a different server. ... for it to also be "userX." ... Is there a way to change a "login name"? ...
    (microsoft.public.sqlserver.programming)
  • Machine and User credentials
    ... Is it possible, using Windows XP Pro security mechanisms, to authenticate access to a shared folder using BOTH machine and user credentials? ... i.e., userX can only login from machineX, not machineY. ... userY can only login from machineY or machineX, but not from any other machine. ...
    (microsoft.public.windowsxp.security_admin)
  • Machine and User credentials
    ... Is it possible, using Windows XP Pro security mechanisms, to authenticate access to a shared folder using BOTH machine and user credentials? ... i.e., userX can only login from machineX, not machineY. ... userY can only login from machineY or machineX, but not from any other machine. ...
    (microsoft.public.security)