thank you... 🙂

i was looking for such a stuff... this can be used for anything which needs to be applied on all the tables...

viz.

sp_msforeachtable "grant select on ? to user1"