How do you restrict access to rows of a database?
Answers were Sorted based on User's Feedback
Answer / subhash
In XI version it can be done by using row-level security in
designer module whereas in 5i/6i it is done by supervisor.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sivakumar.v
In universe level , we can use row level restriction option and restrict by providing access to group or user on which data they should have access.
In database level, we can restrict data by providing custom access to the user and it can be implemented in universe level using @BOuser
Is This Answer Correct ? | 0 Yes | 0 No |
Explain what task is 98% of the required work of a business analyst?
Hi, Webi report is created using universeA and this report needs to be shifted to UniverseB.So when i am trying to change report to new universeB from edit query properties, the report just hangs at the point of changing source to target.The reports which hangs mainly are the crosstab reports that has large data and many formulas. Any help on this is much appreciated. Thanks
Say, the query gets executed and we got the results. In case if we have a large number of rows, how can we know the exact no of rows returned?
why you create universe and creating reports based on that? why dont we go for crystel reports and generate reports directly?tell me the advantages?please answer to this question.
What is the difference between the prompt and cascading prompt
What are the advantages of setting up LOVs in the Universe?
2 Answers Cap Gemini, Deloitte,
What is the difference between sub-query & co-related sub query?answer ASAP....... thanks in advance..............Prakash
3 Answers iFlex, Maintec, TCS,
What is the difference between Report Bursting and Report scheduling?Explain both of them in detail?
difference between xir2 and 6.5 version
Can master data change???if yes then how it'll change.....please explain with example...... thanx
What Is The Difference Between Oltp And Olap?
wha is the difference b/w merge dimension and combining two different data providers?