SQL Server Security
As documented in SQL Server BOL, aliases have been deprecated for some time and we are planning to remove them from the product in the next release.
We will greatly appreciate any feedback or comments regarding this change. We would like to know how our customers will be affected by this change and analyze if there is anything we can do to help you to make the transition easier.
Thanks a lot,
-Raul Garcia
SDE/T
SQL Server Engine
We are also planning on removing the following stored procedures in the next release:
sp_addgroup, sp_dropgroup, sp_changegroup, sp_helpgroup
Thanks,
Jack Richins
SDE
SQL Server Engine
.
Alias were superseded by roles in SQL Server 2000, for more information you can visit the following BOL pages:
ˇ¤ Deprecated Database Engine Features in SQL Server 2005 (under ˇ°Features Not Supported in the Next Version of SQL Serverˇ± ): http://msdn2.microsoft.com/en-us/library/ms143729.aspx
ˇ¤ Create User (TSQL): http://msdn2.microsoft.com/en-us/library/ms173463.aspx
ˇ¤ Create role (TSQL): http://msdn2.microsoft.com/en-us/library/ms187936.aspx
Hopefully these links will help on the migration process to use roles, and it will also help to clarify the nature of the planned change in the next release of SQL Server. Thanks a lot, for your feedback.
-Raul Garcia
SDE/T
SQL Server Engine
Raul
Have you had any feedback in this regard, would like to know more about it.
I have not seen aliases in a very long time - I would have to go back to my SQL Server 6.5 days. I look after 70+ production SQL Server (6.5,7, 2000, & 2005) and will lose no sleep on this.
I haven't seen them at any site in the past few years at least.
-Sue
They will be removed on the next release.
-Raul Garcia
SDE/T
SQL Server Engine
Removal would be a good thing as I get too many questions from junior developers about what I should and should not be using.