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

    Hi!
    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!
    THANK YOU.
    Kind regards,
    Christian
    Denmark

Share This Page

Sponsored link: