|
|
DTW Administration / Setup / General / Users / User Authorization
API Users / User Permission
USR3 - User Authorization Table
User Permission UserPermission Object· Table: USR3
Parent: Users Users Object· Table: OUSR
User Autorization Tree OUPT SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | UserLink KEY UNIQUE | User Link | Int | 6 | OUSR Users | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| PermId | Authorization ID | nVarChar | 20 | OUPT User Autorization Tree | ||||
| Permission | Authorization | VarChar | V) Various F) Full R) Read Only N) None U) Undefined Type | 1 | N |
Table relationship map
SELECT statement
SELECT
USR3.UserLink AS 'User Link',
USR3.PermId AS 'Authorization ID',
USR3.Permission AS 'Authorization'
FROM USR3 AS USR3
Related information
User Permission UserPermission Object· Table: USR3
UserPermission is a business object that enables to set the authorization of a specified user to a UserPermissionTree.
Source table: USR3.
Parent: Users Users Object· Table: OUSR User Autorization Tree OUPT SQL Table
Users OUSR SQL Table
Users
Object
UserPermission
Enumeration
Method
Property
Permission
DB
PermissionID
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
