I have a database in which i have several tables and views. The views are created from the data of these different tables.
There are 3 tables in question here. Now I have 2 users to whom i am handing over the account to. They are not SQL savvy so I only want them to be able to only upload the data in these tables. Since they are not SQL savvy i fear that they might delete something. So i want to restrict their function. Table A, B and C.
1. I want them to be able to only upload the data in Table A and B but they should not be able to delete or drop anything from these 2 tables.
2. Now i have another table which is table C in which i want them to be able to delete and upload both...
What should i do Please help. Thanks in advance.