greetings, i want to create database with the following condition No one can do any of the below points except 2 domain accounts1 – Cannot export database structure, records2 – Cannot delete records 3 – Cannot create table, alter table, drop tableRest other user can insert record or update records please advice what shuld i do i need the answer ASAPnote: i have many users on this server
if i get you correctly then for those 2 account, you can configure db_owner and for rest of the account, you can put db_datareader and if need writing as well then db_datawriter.
thanks for your replay, you mean if grant db_datareader to the users will prevent the database from copy , delete and all the other points
you asking for file level permission or database level? think first what level of security you looking for. if its related to database level then yes, db_datareader will not allow them to modify data