Database Roles
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.
See Also
Creating an SQL Server User ID
Last updated on Wednesday, October 18, 2006
© 2006 Microsoft Corporation. All rights reserved.