assign read only permission to all SQL database by default

Posted on 2012-09-11
Last Modified: 2012-09-13
Hi Team
        we use SQL 2008, i would like to create one account, this account will have read only permission for all database in this SQL, when i create new database in the future, this account will have read only permission by default. i don't want to assign permission every time. for example, the SA account will have full control for all database. but i would like give one account read only permission. any advice?
Question by:beardog1113
    LVL 31

    Accepted Solution

    LVL 29

    Assisted Solution

    by:Rich Weissler
    If you assign that one account read permission to the model database, it will have read permission to new databases created on that server.
    LVL 22

    Expert Comment

    Could modify the model data base under security\users  section and add the "read only" user there.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now