Home Forums SQL Server 2008 Security (SS2K8) Granting select to all databases current and future? RE: Granting select to all databases current and future?

  • September 21, 2013 at 6:14 am

    #1652133

    Jeff Moden (9/20/2013)

    lbrady (9/20/2013)

    I have a user who needs select permissions to all databases on a server.

    From a data security aspect, I'd really want to know why that's necessary. I'd also get the head of IT to sign off on that request in writing.

    Yes, Jeff. A valid concern. However, this department owns the server. I only support them in a very limited capacity (backups and permissions - the use of the term 'security' is purposefully omitted.) From a company standpoint, it is all development and therefore no PII.