Welcome to MSSQL Forum!
MSSQL Forum - Discussions about Microsoft SQL Server

You are currently viewing our community forums as a guest user. Sign up or
Having an account grants you additional privileges, such as creating and participating in discussions.

Create an user with access to only certain tables - but access to add new tables?

Discussion in 'General' started by ChristianHB, Mar 14, 2013.

  1. ChristianHB

    ChristianHB New Member

    I have worked with MSSQL some years, but not as my primary tasks and probably only doing quite basic stuff.. Now I have a problem that I don't know how to solve: We have a database containing 14000+ tables (from Dynamics NAV by the way) which makes some external integrated systems break.. If that external system could access the database and only "see" the 30-40 relevant tables that would solve the problem perfectly.. BUT the twist is that this system needs to be able to create new tables! Hence a really limited user would not work..

    So I guess my question really is:
    • Is it possible to create a user with access to only certain tables?
    • Can this user be given the rights to create new tables (and of course access these too)?

    Answers and advice will be much appriciated!
    Kind regards,

Share This Page