• Brian,

    These are SQL Server users. As I said, after giving them db_datawriter role some of them assume it right away, but for some other I have to go into "Permissions" and manually click on each object to grant access.

    By the way, if you assign db_datawriter role to a user and then go to the User Properties - Permissions screen,  should the boxes for some objects be already marked (since the given role has granted those permissions)? For me, whatever role I give those boxes always stay unchecked. I have SQL-2000 on Win2000.

    Thank you.