Aliases (Level 4)
| SQL Server 6.x | SQL Server 2000 |
|---|---|
| An alias allowed a user to temporarily assume the identity of another user within a database and perform actions as the aliased user. For example, the database owner could be aliased to a user so they could act as that user, if the user were on vacation. | Roles have replaced aliases. Because a user can belong to more than one role at a time, it is no longer necessary to assume the identity of another. Users belonging to the same roles have the same permissions automatically, assuming permissions are only applied at the role level, not the user level.
Expect different results as compared to earlier versions of SQL Server. Use roles instead of aliases. For more information about database roles, see Managing Permissions. |