SQL Server Performance

Restrication on create database in SQL Server 2005

Discussion in 'SQL Server 2005 General DBA Questions' started by myworld, Aug 23, 2010.

  1. myworld New Member

    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
  2. ashish287 New Member

    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.
  3. myworld New Member

    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
  4. ashish287 New Member

    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

Share This Page