biuan SAP® BUSINESS ONE SDK
SQL Administration / Users / User Authorization
DTW Administration / Setup / General / Users / User Authorization
API Users / User Permission
USR3 - User Authorization Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
UserLink KEY UNIQUEUser LinkInt
6OUSR
Users		PRIMARYYes
PermIdAuthorization IDnVarChar
20OUPT
User Autorization Tree
PermissionAuthorizationVarChar
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
SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates