user cannont see tables under database

• SQListic

  SSCertifiable

  Points: 6904

  More actions

  August 27, 2012 at 6:05 pm

  #265937

  Hi DBA's

  Generally i create database level roles and assign them to the logins..

  Thi role has select,update,insert permissions

  I did the same in a different server ,But the issue is that the developer cannot see tables under database ..

  Specifically this database has 12 schemas init. do i need check all 12 schemas in "schemas owned by this user" database user properites ?

  Please Help

  Thanks

• Ant-Green

  SSC Guru

  Points: 113504

  More actions

  August 28, 2012 at 2:08 am

  #1530613

  Grant view definition on the schemas the developer is allowed to see or the database.