Filter
Top Products
· Privilege information (only if -p is specified)
Note:
If a DSI exists for which database space has been allocated, the following information is also printed:
- Information on the allocated DSI (DSI name and type)
- Information on the table related to the DSI (schema name and table name)
- Information on the DSO related to the DSI (DSO name)
- Allocation size
SEQUENCE specification
· Sequence name
· Name of the database to which a sequence belongs
· Name of the schema to which a sequence belongs
· Sequence creator
· Sequence definition date and time
· Sequence number increment interval
· Initial sequence number
· Maximum sequence number
· Minimum sequence number
· Whether to use sequence numbers cyclically
· Number of memory spaces allocated to sequence numbers and number of memory spaces retained with
sequence numbers
· Whether to ensure a sequence between clusters
USER specification
· User name
· User type
· User management type
· Password status
· User creator
· User definition date and time
· Last date and time when the user information was altered (using the ALTER USER statement)
· Last date and time when the user was connected to a database
· Number of times the user failed to connect to a database
· Name and value of each parameter set for the user
ROLE specification
· Role name
· User who defined the role
· Role definition date and time
· Role update date and time
· Resource type
· Database name
· Schema name
· Table name (output if the resource type is TABLE)
· Procedure routine name (output if the resource type is PROCEDURE)
· Function routine name (output if the resource type is FUNCTION)
· Sequence name (output if the resource type is SEQUENCE)
· Trigger name (output if the resource type is TRIGGER)
· Schema name (output if the resource type is SCHEMA)
· Database space name (output if the resource type is DBSPACE)
· Privilege type
· Grantor name
· Grantee names
· Whether the user has the privilege to grant a role
2.14.2 rdbprt command specification method
Figure: Sample database list print specification and Figure: Sample definition information print specification show
sample specifications of the rdbprt command. For more information on specifying the rdbprt command, refer to the
man command (under UNIX) or the SymfoWARE/RDB online manual (under Windows NT).
Sample database list print specification
This example prints a list of all databases in a target SymfoWARE/RDB system.
91