Posted by Marcin A. Guzowski on 08/16/07 13:38

rhaazy pisze:
> The error message is simply that my user didn't have permission to
> execute the statement.
>
> I would like to be able to grant the user insert, update, delete,
> select on all tables in a particular database.(remotely or local, both
> situations are possible)
>
> How would I do this?

Permissions are assigned to logins/users and there is no difference
between remote and local scenario.

If you want all DML operations granted on all tables in particular
database, simply grant two database roles to your database user:

USE your_database;
GO
EXEC sp_addrolemember N'db_datareader', N'database_user';
GO
EXEC sp_addrolemember N'db_datawriter', N'database_user';
GO



--
Best regards,
Marcin Guzowski
http://guzowski.info

[Back to original message]