Hi,

Is there any way to grant ALLpermissions, for ALL tables and procs in a database, to a user/role in one fell swoop? I know I can use GRANT ALL to do all the permissions for ONE object, but I want to do all objects. - at least all the "non system" ones.

I do not want them to have statement permissions.

IT seems like a royal PITA to have to do it one at a time - especially with all the stored procs I've got.

Thanks,
Ken