|
|
SAP Business One SDK 10.0 - Database Tables Reference |
User Authorization
Table Name: USR3
Table Description: User Authorization
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| UserLink | User Link | Int | 6 | OUSR | Â | Â | Â |
| PermId | Authorization ID | nVarChar | 20 | OUPT | Â | Â | Â |
| Permission | Authorization | VarChar | 1 | - | N | V | Various |
| Â | Â | Â | Â | Â | Â | F | Full |
| Â | Â | Â | Â | Â | Â | R | Read Only |
| Â | Â | Â | Â | Â | Â | N | None |
| Â | Â | Â | Â | Â | Â | U | Undefined Type |
| EffPerm | Effective Authorization | VarChar | 1 | - | N | V | Various |
| Â | Â | Â | Â | Â | Â | F | Full |
| Â | Â | Â | Â | Â | Â | R | Read Only |
| Â | Â | Â | Â | Â | Â | N | None |
| Â | Â | Â | Â | Â | Â | U | Undefined Type |
| Key | Unique | Field |
| PRIMARY | Yes | UserLink |
| Â | Â | PermId |