db_accessadmin?
-
OK, so as I understand it the db_accessadmin role got merged into db_securityadmin in recent versions of SQL server? This is fine, it's better this way. My question is, when did it happen? I try to cater for all reasonable flavours of SQL server in my system, I recently took great joy in removing support for SQL 7 (The last client using it paid me to migrate their data to 2008r2 via 2005). Now I'm trying to set up a login with both db_accessadmin & db_securityadmin rights. Or just db_securityadmin, if appropriate. So I need to know which release they merge in. Google is useless on this, so is MSDN. I could just try to grant the right and suppress the error if it fails, On Error resume next anyone ;P
One day we'll look back on this and plow into a parked car.
-
OK, so as I understand it the db_accessadmin role got merged into db_securityadmin in recent versions of SQL server? This is fine, it's better this way. My question is, when did it happen? I try to cater for all reasonable flavours of SQL server in my system, I recently took great joy in removing support for SQL 7 (The last client using it paid me to migrate their data to 2008r2 via 2005). Now I'm trying to set up a login with both db_accessadmin & db_securityadmin rights. Or just db_securityadmin, if appropriate. So I need to know which release they merge in. Google is useless on this, so is MSDN. I could just try to grant the right and suppress the error if it fails, On Error resume next anyone ;P
One day we'll look back on this and plow into a parked car.
Hi, Looking on MSDN, it looks like the last version that the db_accessadmin role was available was SQL Server 2000. I have attached the links for the Fixed Server Roles in SQL Server from 2000 onwards. http://technet.microsoft.com/en-us/library/cc966453.aspx[^] - 2000 http://msdn.microsoft.com/en-us/library/ms175892(v=sql.90).aspx[^] - 2005 http://msdn.microsoft.com/en-us/library/ms175892(v=sql.100).aspx[^] - 2008 http://msdn.microsoft.com/en-us/library/ms175892(v=sql.105).aspx[^] - 2008 R2 Hope this helps! :cool:
Personal Blog: A Software Programmer Twitter: JammoD
-
Hi, Looking on MSDN, it looks like the last version that the db_accessadmin role was available was SQL Server 2000. I have attached the links for the Fixed Server Roles in SQL Server from 2000 onwards. http://technet.microsoft.com/en-us/library/cc966453.aspx[^] - 2000 http://msdn.microsoft.com/en-us/library/ms175892(v=sql.90).aspx[^] - 2005 http://msdn.microsoft.com/en-us/library/ms175892(v=sql.100).aspx[^] - 2008 http://msdn.microsoft.com/en-us/library/ms175892(v=sql.105).aspx[^] - 2008 R2 Hope this helps! :cool:
Personal Blog: A Software Programmer Twitter: JammoD