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

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
 
Top