View any definition rights for all database pls RRS feed

  • Question

  • hi, all

    i need to create a user on production, production server have 10+ databases, the new user can view all the database definitions and search all tables, how to grant the rights?

    step 1: create a login,

    step 2: each databases create a user, then 1 by 1 database to grant view any definition and db_datareader rights

    is there any easy way to achive this? thanks.



    Wednesday, August 31, 2011 9:21 AM


All replies