Contains information about permissions that have been applied to security accounts with the GRANT and DENY statements. This table is stored in each database.
| Column name | Data type | Description |
|---|---|---|
| id | int | ID of object to which these permissions apply. |
| uid | smallint | ID of user or group to which these permissions apply. |
| action | tinyint | Can have one of these permissions: 26 = REFERENCES 193 = SELECT 195 = INSERT 196 = DELETE 197 = UPDATE 198 = CREATE TABLE 203 = CREATE DATABASE 207 = CREATE VIEW 222 = CREATE PROCEDURE 224 = EXECUTE 228 = BACKUP DATABASE 233 = CREATE DEFAULT 235 = BACKUP LOG 236 = CREATE RULE |
| protecttype | tinyint | Can have these values: 204 = GRANT_W_GRANT 205 = GRANT 206 = REVOKE |
| columns | varbinary(4000) | Bitmap of columns to which these SELECT or UPDATE permissions apply. Bit 0 indicates all columns; bit 1 means permissions apply to that column and NULL means no information. |
| grantor | smallint | User ID of the user who issued the GRANT or REVOKE permissions. |