Re: SQL2000 UserPermissions for Database


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
    ... SQL Server MVP ... "Arejan" wrote in message ... I need to populate a combobox for login for userx which will get this ...
    (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)