Hi, I just wanted to check if there is a way to grant access to system tables and views such as sys.tables and sys.schemas to the users other than granting "sysadmin" role. I am not sure what kind of privileges the sysadmin role possess so would like to find if there are other roles or privileges available to access system tables and views. [cid:image001.jpg@01D64952.B2EE5CC0] Suresh Devarakonda 84.51http://www.8451.com/° TDO - Database Support Team D: 513.632.3692 M: 859.512.1839 A: 100 W. 5th Street, Cincinnati, Ohio 45202 Cincinnati | Chicago | New York | Portland Facebookhttps://www.facebook.com/8451group/?ref=aymt_homepage_panel LinkedInhttps://www.linkedin.com/company/84-51/?trk=biz-companies-cym Instagramhttps://www.instagram.com/84.51/ Twitterhttps://twitter.com/8451group Please consider the environment before printing this email.
