Re: SQL2000 UserPermissions for Database

Thanks Uri

EXEC sp_grantdbaccess 'Login', 'Userx'

its EXEC sp_grantdbaccess 'Userx'

will it cover
public
db_backupoperator
db_datread
db_datawrite

or only db_datread




1.whats the command to select only databases whose user is "Userx"
set the dataccess for databaseA and databaseF



here "Userx" can r-w-backup databaseA and databaseF

i want to
select all databases that "Userx" can access.

which will display

databaseA
databaseF

Thank You

.

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
    ... 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)
  • SQL2000 UserPermissions for Database
    ... created a user Userx ... and set the dataccess for databaseA and databaseF as follows ... Sqldmo and SQLDMO.RegisteredServer needs client tools to be ...
    (microsoft.public.sqlserver.security)