SQL Server 2016 and LLBLGen v1.0.2004.2

Posts   
 
    
Shawn1763
User
Posts: 1
Joined: 23-Oct-2018
# Posted on: 23-Oct-2018 18:15:54   

First of all, I know this version is very old, but I'm supporting an older application! cry

We have moved our Financial system from an Oracle DB to a SQL Server 2016 version. I need to build my LLBLGen project for certain tables in the new database owned by, let's say, "FINANCE" user (dbo). I've been assigned a login "USER1", for example. Does "USER" have to be a member of the "db_owner" role, in order to read the schema catalog?

If "USER1" is a member of the "db_owner" role, then how can DB Admin restrict the catalog information only to handful of tables to the "USER1"?

Thanks.

Walaa avatar
Walaa
Support Team
Posts: 14946
Joined: 21-Aug-2005
# Posted on: 23-Oct-2018 22:50:07   

First things first.

v. 1.x is out of support. Plus it doesn't support SQL Server 2016.

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 24-Oct-2018 10:01:57   

You have to upgrade to a later version of LLBLGen Pro to get support for newer versions of SQL Server as the meta data format changed, sorry.

Frans Bouma | Lead developer LLBLGen Pro