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:
Answers and advice will be much appriciated!
THANK YOU.
Kind regards,
Christian
Denmark
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