Group Attributes

The following lists the available default group schema attributes. The out-of-the-box schema attributes must be defined as string if not specified.

Roles

The Role group schema contains the following attributes by default.

Role's unique identifier name

This is an Account ID which must not be changed.

Indicates if the role is a default entitlement for any user

Indicates if the role is a current entitlement for any user

Indicates if the role is inherited by another entitlement

Owner of the role

Specifies a comment for the role

List of inherited roles

List of child database roles assigned to the database role

Direct privileges assigned to the role

Database Roles

The Database Role group schema contains the following attributes by default.

The Database Role's name

This is an Account ID which must not be changed.

Indicates if the database role is a default database role

Indicates if the database role is a current role

Indicates if the database role is inherited by another database role

Owner of the database role

Comment for the database role

List of child database roles assigned to the database role

Direct privileges assigned to the database role

Configurable Group Attributes

The following is a list of attributes that are not provided out of the box. You can add them to your schema to view various Snowflake user information.

Timestamp indicating time when role was created.