Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

In which tabels the Roles, Usernames, Transaction codes, Change Queues

Former Member

‎07-20-2007 8:57 AM

0 Kudos

Hi All,

These questions are based on basis:

WIl any one tell me where the Roles, User Names for that role, tcodes, change queues are stored.

how they interlink to each other, how can we find the single and composite roles in the table. how can we find what time it is created and when it is changed.

how can we find how much time the request in change queue....

Thanks,

Ravi

4 REPLIES 4

Former Member

‎07-20-2007 9:01 AM

0 Kudos

Hi,

check table

TSTC-TCODE

ROLE - AGR_DEFINE-AGR_NAME

User Names - USR01-BNAME

thanks.

REWARD IF HELPFUL.

Former Member

‎07-20-2007 9:01 AM

0 Kudos

Hi ravi,

Check all the tables starting with AGR_*

Important is AGR_USERS.

Regards,

Atish

Message was edited by:

Atish Sarda

Former Member

‎07-20-2007 9:05 AM

0 Kudos

Hi ravi ,

there is one function group- PRGN which can give all info regarding the autherisation .

Former Member

‎07-20-2007 9:06 AM

0 Kudos

Hi

check the following Tables

AGR_DEFINE - Role definition

AGR_USERS - Assignment of Roles to users

AGR_TEXTS - Role Descriptions

AGR_TCODES - Assignment of Roles to Tcodes

AGR_PROF - profile Name for Role

AGR_1250 - Authorization data fro activity group

AGR_1252 - Orgn elements for Authorizations

USR10 - Role Definition

UST12 - User Master Authorizations

<b>Reward points for useful Answers</b>

Regards

Anji