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. 

Suresh Devarakonda 84.51°                             TDO -  Database Support Team D: 513.632.3692 M: 859.512.1839 A: 100 W. 5^th Street, Cincinnati, Ohio 45202 Cincinnati  |  Chicago  | New York  |  Portland Facebook LinkedIn Instagram Twitter Please consider the environment before printing this email.