Re: SQL2000 UserPermissions for Database

Arejan
By EXEC sp_grantdbaccess 'Login', 'Userx' , you are only givinng an simple
access to the database
Now that , you add the user to the database fixed role such you mentioned,
just do not make a login to be a member of sysadmin server role




"Arejan" <areejan2000@xxxxxxxxx> wrote in message
news:1165216099.346721.194610@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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



.