O'Reilly logo

Alison Balter's Mastering Access 2002 Enterprise Development by Alison Balter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating Roles

Roles are the equivalent of Windows NT/Windows 2000 groups. You create roles and then grant users membership to those roles. Users who are members of a role inherit the permissions assigned to that role. The process of creating roles and assigning permissions to those roles greatly facilitates the process of administering security. This is because, rather than having to assign specific rights to each user of a system, you can instead assign rights to groups of users.

Types of Roles

SQL Server offers four types of roles. These include:

  • Fixed server roles

  • Fixed database roles

  • User-defined database roles

  • Application roles

Each of these types of roles serves a specific purpose. Generally, you will use several types of roles in combination. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required