Thanks a lot, Greg for the very clear explanation.

I will make the backup and versioning system more reliable, so that i need not worry if someone drops the DB objects...

Thanks ,Lucky for your quick response.

I tried the same , as directed by you.

The following statements are working fine.

Grant Create Table to rolename

Grant Create Procedure to rolename

But when i execute...