Statement | Meaning |
| Defines a user group, possibly with access rights |
| Terminates command input |
| Assigns access rights to a user group |
| Opens a database |
| Deletes one or more user group(s) |
| Withdraws access rights from a user group |
| Outputs information on one or more user group(s) |
| Undoes a statement |
Table 19: Overview of statements
ADD-USER-GROUP
(Defining a user group with or without assigning access rights)
The ADD-USER-GROUP statement allows you to define new user groups. You can define the associated access rights at the same time.
The structure of the user group name depends on the environment in which you are working (see table 18 on "Checking access rights").
You can specify the name of the user group in two different formats:
*KSET-FORMAT and *FREE-FORMAT
*KSET-FORMAT is available for openUTM operation, for example. In this case, the user group name comprises the three parts openUTM host name, openUTM application name and KSET name.
If you do not define access rights for the specified user group, the user group is created, but users in the group cannot access database objects. Access rights must be assigned by means of subsequent GRANT-ACCESS statements (see page GRANT-ACCESS).
ADD-USER-GROUP | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
USER-GROUP-NAME = list-poss(6): *KSET-FORMAT(...) / *FREE-FORMAT(...)
Name of the user group.
*KSET-FORMAT(...)
Specification of the user group.
HOST = <host>
Host computer of the openUTM application (see host, "Checking access rights").
APPLICATION = <appl>
Name of the openUTM application.
KSET = *NONE
No KSET name is specified.
KSET = list-poss(30): <kset>
KSET name of the openUTM application.
*FREE-FORMAT(...)
Specification of the user group.
HOST = <host>
Host computer of the application.
USER-ID = list-poss(30): <userid>
Identification of the application.
USER-ID = *NONE
No identification is specified. The specification *NONE is now only permitted for reasons of compatibility. The corresponding user group name can no longer be used as of UDS/SQL V2.0.
OBJECT = NONE / list-poss(6): *REALM(...) / *RECORD(...) / *SET(...)
The access rights are specified.
NONE
No access rights are assigned.
*REALM(...)
The realm rights are assigned.
NAME = *ALL
The specified access applies to all realms of the database.
This operand must be defined for SQL applications.
NAME = *ALL-EXCEPT(...)
The specified access applies to all realms except those entered here.
NAME = list-poss(30): <realm-name>
The specified access does not apply to these realms.
NAME = list-poss(30): <realm-name>
The specified access applies only to these realms.
RIGHT = ALL
Both read and write access is granted for the realms.
RIGHT = RETRIEVAL
Only read access is granted for the realms.
*RECORD (...)
The rights for record types (in SQL applications: base tables) are assigned.
NAME = *ALL
The specified access applies to all record types (in SQL applications: base tables) in the database.
NAME = *ALL-EXCEPT(...)
The specified access applies to all record types except those entered here.
NAME = list-poss(30): <record name>
The specified access does not apply to these record types.
NAME = list-poss(30): <record-name>
The specified access does not apply to these record types.
RIGHT = ALL
Both read and write access is granted for the record types.
RIGHT = RETRIEVAL
Only read access is granted for the record types.
*SET(...)
The rights for sets (in SQL applications: foreign keys) are assigned.
NAME = *ALL
The specified access applies to all sets (in SQL applications: foreign keys) in the database.
NAME = *ALL-EXCEPT(...)
The specified access applies to all sets except those entered here.
NAME = list-poss(30): <set-name>
The specified access does not apply to these sets.
NAME = list-poss(30): <set-name>
The specified access applies only to these sets.
RIGHT = ALL
Both read and write access is granted for the sets.
RIGHT = RETRIEVAL
Only read access is granted for the sets.
BPRIVACY group names of a version < UDS/SQL V1.2 containing one or more blanks can no longer be defined via the new interface. In these cases, you must define a new group name in compliance with SDF rules of syntax.
Example
The following user groups are defined for the SHIPPING database:
"
D017ZE07________XXXXX___" : all rights"
D017ZE07________YYYYYY__" : retrieval right"
D017ZE07________ZZZZZZ__" : no rights
/ADD-FILE-LINK LINK-NAME=DATABASE,FILE-NAME=SHIPPING.DBDIR
/SELECT-PRODUCT-VERSION PRODUCT-NAME=UDS-SQL, VERSION=02.9B00
/START-UDS-BPRIVACY
***** START BPRIVACY (UDS/SQL V2.9 1801 ) 2019-01-29 09:27:25
% UDS0215 UDS STARTING UDS/SQL V2.9 (LINKED-IN), DATE=2019-01-29 (ILL2038,09:27:25/4TE7)
% UDS0746 UDS PUBSET DECLARATION (CURRENT) FOLLOWS (ILL1746,09:27:25/4TE7)
4TE7: UDS-PUBSET-JV: :IUDS:$XXXXXXXX.PUBSDECL.ALL
4TE7: PUBSETS: *
4TE7: DEFAULT PUBSET: IUDS
4TE7: ------------------------------------------
% UDS0722 UDS ORDER ADD RLOG 190129082724 IN EXECUTION (ILL1283,09:27:25/4TE7)
% UDS0356 UDS EXECUTION OF ORDERS FOR SHIPPING TERMINATED (ILL1309,09:27:25/4TE7)
//ADD-USER-GROUP USER-GROUP-NAME=*KSET-FORMAT(HOST=UTMHOST1,APPLICATION=UTMAWVER,KSET=KSETUPD), -
// OBJECT=(*REALM(NAME=*ALL,RIGHT=ALL),*RECORD(NAME=*ALL,RIGHT=ALL), -
// *SET(NAME=*ALL,RIGHT=ALL))
//ADD-USER-GROUP USER-GROUP-NAME=*KSET-FORMAT(HOST=UTMHOST1,APPLICATION=UTMAWVER,KSET=KSETRTR), -
// OBJECT=(*REALM(NAME=*ALL,RIGHT=RETRIEVAL),*RECORD(NAME=*ALL,RIGHT=ALL), -
// *SET(NAME=*ALL,RIGHT=ALL))
//ADD-USER-GROUP USER-GROUP-NAME=*KSET-FORMAT(HOST=UTMHOST1,APPLICATION=UTMAWVER,KSET=KSETRTR), -
// OBJECT=(*REALM(NAME=*ALL,RIGHT=RETRIEVAL),*RECORD(NAME=*ALL,RIGHT=RETRIEVAL), -
// ,*SET(NAME=*ALL,RIGHT=RETRIEVAL))
//END
% UDS0758 NUMBER OF DML-STATEMENTS AND I/O COUNTERS PER DATABASE (ILL1758,09:27:25/4TE7)
4TE7: DATABASE NAME DMLS LOG READ PHYS READ LOG WRITE PHYS WRITE
4TE7: -------------------------------------------------------------------
4TE7: SHIPPING 13 112 59 42 20
% UDS0213 UDS NORMAL SYSTEM TERMINATION WITH **************13 DML-STATEMENTS 2019-01-29
(ILLY033,09:27:25/4TE7)
***** DIAGNOSTIC SUMMARY OF BPRIVACY
NO WARNINGS
NO ERRORS
NO SYSTEM-ERRORS
***** END OF DIAGNOSTIC SUMMARY
***** NORMAL END BPRIVACY (UDS/SQL V2.9 1801 ) 2019-01-29 09:27:25
END (Terminating command input)
Command input is terminated. Execution begins.
END |
This statement has no operands.
GRANT-ACCESS (Assigning access rights to a user group)
The GRANT-ACCESS statement allows you to assign a user group access rights for realms, record types (RECORDs) and sets.
If a user group already has access rights for an object, the rights specified with this statement are added to them.
GRANT-ACCESS | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
USER-GROUP-NAME = list-poss(6): *KSET-FORMAT(...) / *FREE-FORMAT(...)
Name of the user group.
*KSET-FORMAT(...)
Name of the user group.
HOST = <host>
Host computer of the openUTM application (see host, "Checking access rights").
APPLICATION = <appl>
Name of the openUTM application.
KSET = *NONE
No KSET name is specified.
KSET = list-poss(6): <kset>
KSET name of the openUTM application.
*FREE-FORMAT(...)
Name of the user group.
HOST = <host>
Host computer of the application.
USER-ID = *NONE
No identification is specified.
USER-ID = list-poss(30): <userid>
Identification of the application.
OBJECT = list-poss(6): *REALM(...) / *RECORD(...) / *SET(...)
The access rights are specified.
*REALM (...)
The existing realm rights are changed.
NAME = *ALL
The specified access applies to all realms in the database. This operand must be defined for all SQL applications.
NAME = ALL-EXCEPT (...)
The specified access applies to all realms except those entered here.
NAME = list-poss(30): <realm-name>
The specified access does not apply to these realms.
NAME = list-poss(30): <realm-name>
The specified access applies only to these realms.
RIGHT = ALL
Both read and write access is granted for the realms.
RIGHT = RETRIEVAL
Only read access is granted for the realms.
*RECORD(...)
The existing rights for record types (in SQL applications: base tables) are changed.
NAME = *ALL
The specified access applies to all record types (in SQL applications: base tables in the database.
NAME = ALL-EXCEPT (...)
The specified access applies to all record types except those entered here.
NAME = list-poss(30): <record-name>
The specified access does not apply to these record types.
NAME = list-poss(30): <record-name>
The specified access applies only to these record types.
RIGHT = ALL
Both read and write access is granted for the record types.
RIGHT = RETRIEVAL
Only read access is granted for the record types.
*SET(...)
The existing rights to sets (in SQL applications: foreign keys) are changed.
NAME = *ALL
The specified access applies to all sets (in SQL applications: foreign keys) in the database.
NAME = ALL-EXCEPT
The specified access applies to all sets except those entered here.
NAME = list-poss(30): <set-name>
The specified access does not apply to these sets.
NAME = list-poss(30): <set-name>
The specified access applies only to these sets.
RIGHT = ALL
Both read and write access is granted for these sets.
RIGHT = RETRIEVAL
Only read access is granted for these sets.
Example
The user group "D017ZE07________ZZZZZZ__" (no rights) is assigned all rights for the realm CUSTOMER-ORDER-RLM.
/ADD-FILE-LINK LINK-NAME=DATABASE,FILE-NAME=SHIPPING.DBDIR
/SELECT-PRODUCT-VERSION PRODUCT-NAME=UDS-SQL, VERSION=02.9B00
/START-UDS-BPRIVACY
***** START BPRIVACY (UDS/SQL V2.9 1801 ) 2019-01-29 09:27:59
% UDS0215 UDS STARTING UDS/SQL V2.9 (LINKED-IN), DATE=2019-01-29 (ILL2038,09:27:59/4TE7)
% UDS0746 UDS PUBSET DECLARATION (CURRENT) FOLLOWS (ILL1746,09:27:59/4TE7)
4TE7: UDS-PUBSET-JV: :IUDS:$XXXXXXXX.PUBSDECL.ALL
4TE7: PUBSETS: *
4TE7: DEFAULT PUBSET: IUDS
4TE7: ------------------------------------------
% UDS0722 UDS ORDER ADD RLOG 190129082758 IN EXECUTION (ILL1283,09:27:59/4TE7)
% UDS0356 UDS EXECUTION OF ORDERS FOR SHIPPING TERMINATED (ILL1309,09:27:59/4TE7)
//GRANT-ACCESS USER-GROUP-NAME=*FREE-FORMAT(HOST=IBAPROD1,USER-ID=ZZZZZZ),-
// OBJECT=(*REALM(NAME=CUSTOMER-ORDER-RLM,RIGHT=ALL),*RECORD( NAME=*ALL,RIGHT=ALL), -
// *SET(NAME=*ALL,RIGHT=ALL))
//SHOW-USER-GROUP USER-GROUP-NAME=*FREE-FORMAT(HOST=IBAPROD1,USER-ID=ZZZZZZ),OUTPUT=SYSOUT
//END
DATABASE NAME : $XXXXXXXX.SHIPPING
SCHEMA NAME : MAIL-ORDERS
****************************************************************
ACCESS RIGHTS FOR USERGROUP : IBAPROD1________ZZZZZZ__
RIGHTS ON REALMS
+--------------------------------+-----------------------+
! ! R I G H T !
! +-----------+-----------+
! REALM NAME ! RETRIEVAL ! UPDATE !
+--------------------------------+-----------+-----------+
! CUSTOMER-ORDER-RLM ! Y ! Y !
! PURCHASE-ORDER-RLM ! N ! N !
! CLOTHING ! N ! N !
.
.
.
RIGHTS ON RECORDS
+--------------------------------+-----------------------+
! ! R I G H T !
! +-----------+-----------+
! RECORD NAME ! RETRIEVAL ! UPDATE !
+--------------------------------+-----------+-----------+
! CUSTOMER ! Y ! Y !
! CST-ORDERS ! Y ! Y !
! ORD-ITEM ! Y ! Y !
.
.
.
RIGHTS ON SETS
+--------------------------------+-----------------------+
! ! R I G H T !
! +-----------+-----------+
! SET NAME ! RETRIEVAL ! UPDATE !
+--------------------------------+-----------+-----------+
! CST-ORD-PLACED ! Y ! Y !
! CST-O-CONTENTS ! Y ! Y !
! OUTSTANDING ! Y ! Y !
.
.
.
% UDS0758 NUMBER OF DML-STATEMENTS AND I/O COUNTERS PER DATABASE (ILL1758,09:27:59/4TE7)
4TE7: DATABASE NAME DMLS LOG READ PHYS READ LOG WRITE PHYS WRITE
4TE7: --------------------------------------------------------------------
4TE7: SHIPPING 16 84 57 18 16
% UDS0213 UDS NORMAL SYSTEM TERMINATION WITH **************16 DML-STATEMENTS 2019-01-29
(ILLY033,09:27:59/4TE7)
***** DIAGNOSTIC SUMMARY OF BPRIVACY
NO WARNINGS
NO ERRORS
NO SYSTEM-ERRORS
***** END OF DIAGNOSTIC SUMMARY
***** NORMAL END BPRIVACY (UDS/SQL V2.9 1801 ) 2019-01-29 09:27:59
OPEN-DATABASE (Opening the database)
The OPEN-DATABASE statement must be the first one entered.
The OPEN-DATABASE statement allows you to specify the database to be processed by the subsequent ONLINE-PRIVACY or BPRIVACY statements.
OPEN-DATABASE |
DATABASE-NAME = <dbname> |
DATABASE-NAME = <dbname>
Specifies the database for which access authorizations are to be changed. A user of ONLINE-PRIVACY or BPRIVACY can process a database only if it is in his or her identification. A database in a different identification can only be processed using the TSOS identification of the system administrator.
The OPEN-DATABASE statement is always required for ONLINE-PRIVACY.In this case the configuration name of the independent DBH session is specified via LINK-NAME=DATABASE.
REMOVE-USER-GROUP (Deleting one or more user group(s))
The REMOVE-USER-GROUP statement allows you to delete one or more user groups together with their access rights.
REMOVE-USER-GROUP | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
USER-GROUP-NAME = ALL / *ALL / *ALL-EXCEPT(...) /
list-poss(6): *KSET-FORMAT(...) /*FREE-FORMAT(...)
It is specified which user group(s) is (are) to be deleted.
ALLALL / *ALL
All existing user groups are deleted.
*ALL-EXCEPT (...)
All user groups except those entered here are deleted.
NAME = list-poss(6): *KSET-FORMAT(...) / *FREE-FORMAT(...)
The user groups specified here are not deleted.
*KSET-FORMAT(...)
HOST = <host>
Host computer of the openUTM application (see host, "Checking access rights").
APPLICATION = <appl>
Name of the openUTM application.
KSET = *NONE
No KSET name is specified.
KSET = list-poss(30): <kset>
KSET name of the openUTM application.
*FREE-FORMAT(...)
HOST = <host>
Host computer of the application.
USER-ID = *NONE
No identification is specified.
USER-ID = list-poss(30): <userid>
Identification of the application
*KSET-FORMAT(...)
All user groups specified here are deleted.
HOST = <host>
Host computer of the openUTM application (see host, "Checking access rights").
APPLICATION = <appl>
Name of the openUTM application.
KSET = *NONE
No KSET name is specified.
KSET = list-poss(30): <kset>
KSET name of the openUTM application.
*FREE-FORMAT(...)
All user groups specified here are deleted.
HOST = <host>
Host computer of the application.
USER-ID = *NONE
No identification is specified.
USER-ID = list-poss(30): <userid>
Identification of the application.
Example
The user group "D017ZE07________YYYYYY__" is deleted.
/ADD-FILE-LINK LINK-NAME=DATABASE,FILE-NAME=SHIPPING.DBDIR
/SELECT-PRODUCT-VERSION PRODUCT-NAME=UDS-SQL, VERSION=02.9B00
/START-UDS-BPRIVACY
***** START BPRIVACY (UDS/SQL V2.9 1801 ) 2019-01-29 09:27:59
% UDS0215 UDS STARTING UDS/SQL V2.9 (LINKED-IN), DATE=2019-01-29 (ILL2038,09:27:59/4TE7)
% UDS0746 UDS PUBSET DECLARATION (CURRENT) FOLLOWS (ILL1746,09:28:00/4TE7)
4TE7: UDS-PUBSET-JV: :IUDS:$XXXXXXXX.PUBSDECL.ALL
4TE7: PUBSETS: *
4TE7: DEFAULT PUBSET: IUDS
4TE7: ------------------------------------------
% UDS0722 UDS ORDER ADD RLOG 190129082800 IN EXECUTION (ILL1283,09:28:00/4TE7)
% UDS0356 UDS EXECUTION OF ORDERS FOR SHIPPING TERMINATED (ILL1309,09:28:00/4TE7)
//REMOVE-USER-GROUP USER-GROUP-NAME=*FREE-FORMAT(HOST=IBAPROD1,USER-ID=YYYYYY)
//END
% UDS0758 NUMBER OF DML-STATEMENTS AND I/O COUNTERS PER DATABASE (ILL1758,09:28:00/4TE7)
4TE7: DATABASE NAME DMLS LOG READ PHYS READ LOG WRITE PHYS WRITE
4TE7: -------------------------------------------------------------------
4TE7: SHIPPING 7 93 60 25 22
% UDS0213 UDS NORMAL SYSTEM TERMINATION WITH ***************7 DML-STATEMENTS 2015-06-28
(ILLY033,09:28:00/4TE7)
***** DIAGNOSTIC SUMMARY OF BPRIVACY
NO WARNINGS
NO ERRORS
NO SYSTEM-ERRORS
***** END OF DIAGNOSTIC SUMMARY
***** NORMAL END BPRIVACY (UDS/SQL V2.9 1801 ) 2019-01-29 09:28:00
REVOKE-ACCESS (Withdrawing access rights from a user group)
The REVOKE-ACCESS statement allows you to withdraw from a user group access rights for realms, record types (RECORDs) and sets.
Only the access rights specified here are withdrawn. All other access rights are retained.
REVOKE-ACCESS | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
USER-GROUP-NAME = list-poss(6): *KSET-FORMAT(...) / *FREE-FORMAT(...)
Name of the user group.
*KSET-FORMAT(...)
Name of the user group.
HOST = <host>
Host computer of the openUTM application (see host, "Checking access rights").
APPLICATION = <appl>
Name of the openUTM application.
KSET = *NONE
No KSET name is specified.
KSET = list-poss(30): <kset>
KSET name of the openUTM application.
*FREE-FORMAT(...)
Name of the user group.
HOST = <host>
Host computer of the application.
USER-ID = *NONE
No identification is specified.
USER-ID = list-poss(30): <userid>
Identification of the application.
OBJECT = list-poss(6): *REALM(...) / *RECORD(...) / *SET(...)
The access rights are specified.
*REALM(...)
The existing realm rights are changed.
NAME = *ALL
The specified access is withdrawn for all realms in the database.
NAME = *ALL-EXCEPT (...)
The specified access is withdrawn for all realms except those entered here.
NAME = list-poss(30): <realm-name>
The specified access is not withdrawn for these realms.
NAME = list-poss(30): <realm-name>
The specified access is withdrawn for these realms only.
RIGHT = ALL
The realms can no longer be accessed.
RIGHT = UPDATE
The realms can no longer be write-accessed.
RIGHT = RETRIEVAL
This is only possible if the specified user group does not have write (UPDATE) access.
The realms can no longer be accessed.
*RECORD(...)
The existing rights for record types (in SQL applications: base tables) are changed.
NAME = *ALL
The specified access is withdrawn for all record types (in SQL applications: base tables) in the database.
NAME = *ALL-EXCEPT (...)
The specified access is withdrawn for all record types except those entered here.
NAME = list-poss(30): <record-name>
The specified access is not withdrawn for these record types.
NAME = list-poss(30): <record-name>
The specified access is withdrawn only for these record types.
RIGHT = ALL
The record types can no longer be accessed.
RIGHT = UPDATE
The record types can no longer be write-accessed.
RIGHT = RETRIEVAL
This is only possible if the specified user group does not have write (UPDATE) access.
The record types can no longer be accessed.
*SET(...)
The existing rights for sets (in SQL applications: foreign keys) are changed.
NAME = *ALL
The specified access is withdrawn for all sets (in SQL applications: foreign keys) in the database.
NAME = *ALL-EXCEPT (...)
The specified access is withdrawn for all sets except those entered here.
NAME = list-poss(30): <set-name>
The specified access is not withdrawn for these sets.
NAME = list-poss(30): <set-name>
The specified access is withdrawn for these sets only.
RIGHT = ALL
The sets can no longer be accessed.
RIGHT = UPDATE
The sets can no longer be write-accessed.
RIGHT = RETRIEVAL
This is only possible if the specified user group does not have write (UPDATE) access.
The sets can no longer be accessed.
Example
The update right for the realm CUSTOMER-ORDER-RLM is withdrawn from user group "D017ZE07_________ZZZZZZ__".
/ADD-FILE-LINK LINK-NAME=DATABASE,FILE-NAME=SHIPPING.DBDIR
/SELECT-PRODUCT-VERSION PRODUCT-NAME=UDS-SQL, VERSION=02.9B00
/START-UDS-BPRIVACY
***** START BPRIVACY (UDS/SQL V2.9 1801 ) 2019-01-29 09:28:02
% UDS0215 UDS STARTING UDS/SQL V2.9 (LINKED-IN), DATE=2019-01-29 (ILL2038,09:28:02/4TE7)
% UDS0746 UDS PUBSET DECLARATION (CURRENT) FOLLOWS (ILL1746,09:28:02/4TE7)
4TE7: UDS-PUBSET-JV: :IUDS:$XXXXXXXX.PUBSDECL.ALL
4TE7: PUBSETS: *
4TE7: DEFAULT PUBSET: IUDS
4TE7: ------------------------------------------
% UDS0722 UDS ORDER ADD RLOG 190129082802 IN EXECUTION (ILL1283,09:28:02/4TE7)
% UDS0356 UDS EXECUTION OF ORDERS FOR SHIPPING TERMINATED (ILL1309,09:28:02/4TE7)
//REVOKE-ACCESS USER-GROUP-NAME=*FREE-FORMAT(HOST=IBAPROD1,USER-ID=ZZZZZZ), -
// OBJECT=(*REALM(NAME=CUSTOMER-ORDER-RLM,RIGHT=UPDATE))
//SHOW-USER-GROUP USER-GROUP-NAME=ALL,OUTPUT=SYSOUT
//END
DATABASE NAME : $XXXXXXXX.SHIPPING
SCHEMA NAME : MAIL-ORDERS
********************************************************************
ACCESS RIGHTS FOR USERGROUP : IBAPROD1________ZZZZZZ__
RIGHTS ON REALMS
+--------------------------------+-----------------------+
! ! R I G H T !
! +-----------+-----------+
! REALM NAME ! RETRIEVAL ! UPDATE !
+--------------------------------+-----------+-----------+
! CUSTOMER-ORDER-RLM ! Y ! N !
! PURCHASE-ORDER-RLM ! Y ! Y !
! CLOTHING ! Y ! Y !
.
.
% UDS0758 NUMBER OF DML-STATEMENTS AND I/O COUNTERS PER DATABASE (ILL1758,09:28:02/4TE7)
4TE7: DATABASE NAME DMLS LOG READ PHYS READ LOG WRITE PHYS WRITE
4TE7: -------------------------------------------------------------------
4TE7: SHIPPING 17 86 58 18 18
% UDS0213 UDS NORMAL SYSTEM TERMINATION WITH **************17 DML-STATEMENTS 2019-01-29
(ILLY033,09:28:02/4TE7)
***** DIAGNOSTIC SUMMARY OF BPRIVACY
NO WARNINGS
NO ERRORS
NO SYSTEM-ERRORS
***** END OF DIAGNOSTIC SUMMARY
***** NORMAL END BPRIVACY (UDS/SQL V2.9 1801 ) 2019-01-29 09:28:02
SHOW-USER-GROUP (Outputting information on user groups)
Information is output on user groups, i.e. on the access rights the groups have for database objects. The realms, record types and sets are output in ascending order by reference number.
SHOW-USER-GROUP | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
USER-GROUP-NAME = ALL / *ALL / *ALL-EXCEPT(...) / list-poss(6):
*KSET-FORMAT(...)/*FREE-FORMAT(...)
The rights are output.
ALL / *ALL
The rights of all user groups are output.
*ALL-EXCEPT (...)
The rights of all user groups except those entered here are output.
NAME = list-poss(6): *KSET-FORMAT(...) / *FREE-FORMAT(...)
The rights of the specified user groups are not output.
*KSET-FORMAT(...)
HOST = <host>
Host computer of the openUTM application (see host, "Checking access rights").
APPLICATION = <appl>
Name of the openUTM application.
KSET = *NONE
No KSET name is specified.
KSET = list-poss (30): <kset>
KSET name of the openUTM application.
*FREE-FORMAT(...)
HOST = <host>
Host computer of the application.
USER-ID = *NONE
USER-ID = list-poss(30): <userid>
Identification of the application.
*KSET-FORMAT(...)
The rights of the specified user groups are output.
HOST = <host>
Host computer of the openUTM application (see host, "Checking access rights").
APPLICATION = <appl>
Name of the openUTM application.
KSET = *NONE
No KSET name is specified.
KSET = list-poss(30): <kset>
KSET name of the openUTM application.
*FREE-FORMAT(...)
HOST = <host>
Host computer of the application.
USER-ID = *NONE
No identification is output.
USER-ID = list-poss(30): <userid>
Identification of the application.
OUTPUT = list-poss: SYSLST / SYSOUT
The information is output.
SYSLST
Output is to SYSLST.
SYSOUT
Output is to SYSOUT.
Beispiel
See example of GRANT-ACCESS.
UNDO (Undoing a statement)
The last correctly entered statement (except UNDO itself) is not executed. A subsequent UNDO statement undoes the penultimate statement (apart from UNDO), and so on.
UNDO |
This statement has no operands.