Hi Shivaram!

Thanks for the response. Its put me to some rest as i was scared to death yesterday after running the script.

I code i excuted is more or less the same that is available in permission.txt file i had attached earlier. I did some light modification like removing spaces or so and it worked.

But i didnot see any grid as it didnot display one. It only gave me the message as sent to you earlier. Could it be because of executing the DROP #TUser table along with the script????

Please advice.....

Can i get a script / if you could modify your script such that i get something like this...?

Servername

........database name

..................database roles

.........................users

........database name

..................database roles

.........................users

Many thanks Shivam....