Skip to Content
0
Former Member
Sep 06, 2007 at 04:35 AM

SQL Command for deleting T-Code for roles

99 Views

Hi Experts

I want to delete the transaction from the role name by using SQL Command in MS-SQL Server instead of going to /npfcg -> zwa_xyz (role name for user) and transaction code is CR01,CR01,CA01 Etc.,

I have so many transaction code which is taking time to delete one by one.

So is there any SQL Statement to delete the t-code for that rolename

Delete from tablename where t-code=xyz and rolename in ('zwa_xyz',zwa_123')

............

regards