Transact-SQL Reference
syspermissions
Contains information about permissions granted and denied to users, groups, and roles in the database. This table is stored in each database.
| Column name | Data type | Description |
|---|---|---|
| id | int | ID of the object for object permissions; 0 for statement permissions. |
| grantee | smallint | ID of the user, group, or role affected by the permission. |
| grantor | smallint | ID of the user, group, or role that granted or revoked the permission. |
| actadd | smallint | For internal use only. |
| actmod | smallint | For internal use only. |
| seladd | varbinary(4000) | For internal use only. |
| selmod | varbinary(4000) | For internal use only. |
| updadd | varbinary(4000) | For internal use only. |
| updmod | varbinary(4000) | For internal use only. |
| refadd | varbinary(4000) | For internal use only. |
| refmod | varbinary(4000) | For internal use only. |