Unanswered: Grant Permissions to Dropping Procedures, tables, views, functions
I have created a role.
Then i have create a user and assigned the above role. I don't to give this user a admin role.
Now i have given all the Select, insert, update, delete permissions and also create command permissions to this user.
I need to give the drop permissions to this user. Because there are many existing objects in the database.
Is there is any way to give the drop permissions, can someone respond quickly and resolve my issue.