Home > Default > User needs to see only one E&A database for manual data entry

User needs to see only one E&A database for manual data entry

November 30Hits:0
Advertisement
Hi Experts
Please can you suggest a solution for the following requirement.
Requirement is that when a user log in to the Entry & Approval to entry the manual KPIs he should see only the one database which he is allowed to instead of drop-down and select the database which he has to enter the data as multiple models are created to Entry& Approval and Scorecards.
Tried to create model connection for the model and assigned to the user and when i login with that users also all the databases are visible and have to select a database from the list of databases available for entry&approval.
Thanking you,
Regards
Vinay.

Answers

More information, after running a profile trace the following 2 statements, the column with the default on a UDF returns a row while the other default does not.  This might be the cause of this bug.  Is the same logic to generate the object on
the subscriber used to generate the conflict table?  
exec sp_executesql N'
select so.name, schema_name(so.schema_id)
from sys.sql_dependencies d
inner join sys.objects so
on d.referenced_major_id = so.object_id
where so.type in (''FN'', ''FS'', ''FT'', ''TF'', ''IF'')
and d.class in (0,1)
and d.referenced_major_id <> object_id(@base_table, ''U'')
and d.object_id = object_id(@constraint, ''D'')',N'@base_table nvarchar(517),@constraint nvarchar(517)',@base_table=N'[dbo].[repTable]',@constraint=N'[dbo].[DF__repTable__id__117F9D94]'
exec sp_executesql N'
select so.name, schema_name(so.schema_id)
from sys.sql_dependencies d
inner join sys.objects so
on d.referenced_major_id = so.object_id
where so.type in (''FN'', ''FS'', ''FT'', ''TF'', ''IF'')
and d.class in (0,1)
and d.referenced_major_id <> object_id(@base_table, ''U'')
and d.object_id = object_id(@constraint, ''D'')',N'@base_table nvarchar(517),@constraint nvarchar(517)',@base_table=N'[dbo].[repTable]',@constraint=N'[dbo].[DF__repTable__somein__1367E606]'
Pauly C

Read other 3 answers

Tags:

Copyright (C) 2017 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 12 q. 0.055 s.