find out the list of users who have access to all t-codes
starts with 'SU'? thanks in advance all.



find out the list of users who have access to all t-codes starts with 'SU'? thanks in adv..

Answer / Jyoti Devi

ProgrammingCodeAllOther|To find the list of users who have access to all T-codes starting with 'SU', you can use a combination of SQL queries depending on your database structure. Here's an example using a hypothetical database structure:n```sqlnSELECT DISTINCT Users.user_id, Users.username FROM UsersnJOIN UserRoles ON Users.user_id = UserRoles.user_idnJOIN Roles ON UserRoles.role_id = Roles.role_idnWHERE Roles.name LIKE 'SU%'nGROUP BY Users.user_id, Users.usernamenHAVING COUNT(DISTINCT TCodes.tcode) = (SELECT COUNT(*) FROM TCodes WHERE tcode LIKE 'SU%');```

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Programming Code AllOther Interview Questions

Write a code snippet to display an integer in a binary format?

1 Answers  


Is it possible to write JAVA program without including any of the packages,such as "import java.io.*"; bcoz I instantly wrote a code without "import..." statement and runned the program on command Line & it worked. the code is: class Person { String name; int age; Person(String s,int a) { name = s; age = a; } accept() { System.out.println(name+"Hi!!!!!"); System.out.println(age); } } class Demo { public static void main(Strings args[])throws IOException { String name = args[0]; int age = Integer.parseInt(args[1]); Person p = new Person(name,age); p.accept(); } }

1 Answers  


what full form name of B.K.U.

1 Answers  


WORKING STORAGE 01 WS-LENGTH PIC 9(1) VALUE 5. 01 DFHCOMMAREA. COPY ABCDEF (COPYBOOK ABCDEF IS HAVING ONLY ONE VARIABLE OF LENGTH X (100).) .. PROCEDUER DIVISION. ... EXEC CICS XCTL PROGRAM (WS-PGM) COMMAREA (DFHCOMMAREA) LENGTH (WS-LENGTH) RESP (WC-RESPONSE) END-EXEC 1. What will be the value of EIBCALEN in program ABCDEF? 2. What will be length of commarea when in ABCDEF? 3. Will such a code thow any error while linking to called program? Thanks in Advance

0 Answers  


how to test the orientation of the layout in android.to note any changes in the ui design when change orientation

1 Answers  


DAL in oracle

1 Answers  


You have been asked to install a servlet engine (tomcat, glassfish, etc.) for a companies servlets. Assuming the company has an existing web/DBMS server (which may or may not be on the same server), explain in detail how would you implement the development project and a deployment solution.

1 Answers  


Design a timer circuit using VHDL which has the following: input : start_timer(ST) output: long_time(LT) short_time(ST) when the timer is triggered by the ST(either 0 or 1) signal the timer should generate two timing signals accordingly.While the long time is going ON the other should be OFF and vice versa.

1 Answers  


1.Explain what happens to a session object when the browser associated with it is closed? 2.Explain how a session object is created and used. (Note: you are not required to provide the Java statements such as ‘getAttribute’)

1 Answers  


I have multiple datasets and I have to search a particular string in all of them at a single time. Please suggest a full jcl or rexx tool for it.

1 Answers  


Could u please tell me any UNIX scripts that 'll lead to find the network latency of the servers.?or else any unix command to find the network latency of a server?Thnx in advance...

1 Answers   Cap Gemini,


Write a Program to find whether the given number is a Armstrong number.

1 Answers   InterGraph,


Categories