[SQL 2012] how to create user that can login to create and edit but cannot delete?

---

how to create user that can login to create and edit but cannot delete? Posted: 14 Mar 2013 12:45 PM PDT Circumstances require a user that can be restricted to login to a specific database to create and edit data entered into tables but cannot delete anything. I presume this type of security has been around awhile but I could not find anything searching around so I ask is it possible and if so I need to learn how.I may also need some help with the T-SQL because the database is being generated by script that was generated by a tool and I will have to modify that generated sql script to create the user and login.

Can a database be part of an AlwaysOn Availability Group and also mirrored to another server? Posted: 14 Mar 2013 05:39 AM PDT Hi,If a database is already part of an AlwaysOn Availability Group, can it also be mirrored independently to another target server?In other words, can we have mirroring and AlwaysOn-Avail Groups applied on the same databases?

You are subscribed to email updates from SQLServerCentral / SQL Server 2012 / SQL 2012 - General To stop receiving these emails, you may unsubscribe now.	Email delivery powered by Google
Google Inc., 20 West Kinzie, Chicago IL USA 60610