Hi,
Can someone tell me how to manage the permission of the tables and SPs in SQL sever database using the script. Everytime I create a new table or new SP, I have to manually give the permission for the user.

Thanx