For instances of Extended Parallel Server 8.50 that enable this feature, there are no changes to the schema of system catalog tables, but the systabauth system catalog table (for privileges on tables and on views), and the syscolauth system catalog table (for privileges on columns) can store values that were not supported in earlier releases. Values of systabauth.grantor and syscolauth.grantor now can be the identifier of a role. Earlier releases support only the authorization identifier of an individual user in this column.
In the same system catalog tables, systabauth.tabauth and syscolauth.colauth can use uppercase characters, such as 'S' (instead of lowercase 's') for the Select privilege, when systabauth.grantee or syscolauth.grantee (respectively) specifies the name of a role that has received a table or column access privilege WITH GRANT OPTION.
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]