Re: SQL2000 UserPermissions for Database

select database from sysobjects where username ='userx' ?

Try:

SELECT name
FROM master.dbo.sysdatabases
WHERE HAS_DBACCESS(name) = 1
ORDER BY name

--
Hope this helps.

Dan Guzman
SQL Server MVP

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

Dan
i get

Userx databaseA db_backupoperator MemberOf
Userx databaseA db_datareader MemberOf
Userx databaseA db_datawriter MemberOf
Userx databaseA Userx MemberOf
Userx databaseF db_backupoperator MemberOf
Userx databaseF db_datareader MemberOf
Userx databaseF db_datawriter MemberOf
Userx databaseF Userx MemberOf


I need to populate a combobox for login for userx which will get this

databaseA
databaseF

select database from sysobjects where username ='userx' ?


.

Relevant Pages

  • Re: SQL2000 UserPermissions for Database
    ... EXEC sp_grantdbaccess 'Login', 'Userx' ... installed in a PC in lan? ... are there any dlls that can be included to run SqlDmo? ... and set the dataccess for databaseA and databaseF as follows ...
    (microsoft.public.sqlserver.security)
  • Re: SQL2000 UserPermissions for Database
    ... I need to populate a combobox for login for userx which will get this ... select database from sysobjects where username ='userx'? ...
    (microsoft.public.sqlserver.security)
  • Re: SQL2000 UserPermissions for Database
    ... its EXEC sp_grantdbaccess 'Userx' ... set the dataccess for databaseA and databaseF ... select all databases that "Userx" can access. ...
    (microsoft.public.sqlserver.security)