SYSIBM.SYSROUTINEAUTH
                        www.cadcobol.com - linguagem de programação COBOL

Volta a página anterior

Volta ao Menu das SYSIBM

Volta ao Menu Principal


Desenvolvido por DORNELLES, Carlos Alberto - Analista de Sistemas - Brasília DF.

Records the privileges that are held by users on routines. (A routine can be a user-defined function, cast function, or stored procedure.)

Nome da coluna Tipo do dado Descrição Uso
 GRANTOR  CHAR(8) NOT NULL  Authorization ID of the user who granted the privilege.  G
 GRANTEE  CHAR(8) NOT NULL  Authorization ID of the user who holds the privilege or the name of a plan or  package that uses the privilege. Can also be PUBLIC for a grant to PUBLIC.  G
 SCHEMA  CHAR(8) NOT NULL  Schema of the routine  G
 SPECIFICNAME  CHAR(18) NOT NULL  Specific name of the routine. An asterisk (*) if the privilege is held on all routines  in the schema.  G
 GRANTEDTS  TIMESTAMP NOT NULL  Time when the GRANT statement was executed.  G
 ROUTINETYPE  CHAR(1) NOT NULL  Type of routine:

 F      User-defined function or cast function
 P      Stored procedure		  G
 GRANTEETYPE  CHAR(1) NOT NULL  Type of grantee:

 blank    An authorization ID
 P           An application plan or package. The grantee is a package if COLLID is not               blank.
 R           Internal use only		  G
 AUTHHOWGOT  CHAR(1) NOT NULL  Authorization level of the user from whom the privileges were received. This  authorization level is not necessarily the highest authorization level of the grantor.

 This field is also used to indicate that the privilege was held on all schemas by the  grantor.

 blank      Not applicable
 1             Grantor had privilege on schema.* at time of grant
 L            SYSCTRL
 S            SYSADM		  G
 EXECUTEAUTH  CHAR(1) NOT NULL  Whether GRANTEE can execute the routine:

 Y            Privilege is held without GRANT option.
 G            Privilege is held with GRANT option.		  G
 COLLID  CHAR(18) NOT NULL  If the GRANTEE is a package, its collection name. Otherwise, the value is blank.  G
 CONTOKEN  CHAR(8) NOT NULL  If the GRANTEE is a package, the consistency token of the DBRM from which the  package was derived. Otherwise, the value is blank.  G
 IBMREQD  CHAR(1) NOT NULL  A value of Y indicates that the row came from the basic machine-readable material  (MRM) tape. For all other values, see Release dependency indicators in topic D.0.  G