Database Roles
5/10/2007
Using database roles, you can collect users into a single unit to which you can apply specific permissions. All members of a specific role share the same permissions that are granted to, denied to, or revoked from that role. The permissions are applied automatically when a user becomes a member of the role.
The following table shows the predefined database roles exposed in the Windows XP Embedded component database.
| Role | Description |
|---|---|
WES_Reader |
Members have read-only access to the component database. |
WES_Importer |
Members have read and write access to the component database. |
WES_Admin |
Members are equivalent to WES_Reader and WES_Importer, with the added ability to delete from the component database. |
You can assign any one of these roles to a user when you create a SQL Server user ID for that user.