user cannont see tables under database

  • 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

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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply