Find out the roles which gives access to all tables in SAP?
Thanks in advance.



Find out the roles which gives access to all tables in SAP? Thanks in advance...

Answer / Munesh Singh

ProgrammingLanguagesAllOther|To find out the roles that give access to all tables in SAP, you need to query your database according to its structure. Here's an example using a hypothetical database structure:n```sqlnSELECT DISTINCT role_name FROM RolesnJOIN RoleTableAccess ON Roles.role_id = RoleTableAccess.role_idnWHERE table_name IN ('table1', 'table2', ..., 'table n');```

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Programming Languages AllOther Interview Questions

How to call a C++ function which is compiled with C++ compiler in C code?

1 Answers   Yahoo,


Wrtite a JCL for sorting a file with start from 36 postion lenth 9 excluding a num eq to 98768. for 3 marks mainframe

1 Answers  


1. Consider the following input and generate the object code using single pass assembler. JOHN START 0 USING *,15 L 1,FIVE A 1,FOUR ST 1,TEMP FOUR DC F’4’ FIVE DC F’5’ TEMP DS ‘F END

1 Answers   Wipro,


Diff between IF and where ?

1 Answers   Accenture,


how to convert the data from HTML file to SAS dataset?

1 Answers   Accenture,


What is SAP TAO? · Which Version you are using? · What is the Latest Version in SAP TAO? · What are the Advantages in SAP TAO? · What are the Patches required for SAP TAO? · What is BPT? · Difference between BPT & SAP TAO? · Which Framework using for SAP TAO? · What is CBASE? · What is the SAP TAO Architecture? · What are the Prerequisites for SAP TAO? · SAP Solution Manager Mandatory for SAP TAO 1.0? · SAP Solution Manager Mandatory for SAP TAO 2.X? · What is UI Scanner? · What is Inspector? · How many ways to Create a components using TAO 1.0? · How many ways to Create a components using TAO 2.x? · Which service pack required for SAP TAO 2.7? · What is Import/Export? · What is Consolidate?

1 Answers   Cognizant,


What is the use of sas software? Is sas and sap are different?

1 Answers  


7.x=10; y=20; x<<2=? x<<1=? y>>2=?

1 Answers  


In java without use of main() how to execute the program

0 Answers  


1. What coding languages are you comfortable with?

1 Answers  


if we want to move all the items that are already added in a combobox into an empty list box or vice-versa then how can it possible in vb or C# ?

1 Answers  


When will you use shell script/Perl ahead of C/C++?

1 Answers   Yahoo,


Categories