First of all, I know this version is very old, but I'm supporting an older application!
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.