google-code-export / biolink

Automatically exported from code.google.com/p/biolink
0 stars 1 forks source link

Non-SA users that have the SQL Server SysAdmin role should be treated as if they are the 'sa' user #202

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
SQL Server users who have the SysAdmin role are currently not given full access 
by BioLink unless their username is 'sa'. This behaviour is a throwback from 
the early days of sql server when 'sa' was given special privileges by BioLink. 
These privileges should also be given to those users who have been granted the 
SysAdmin server role by a SQL Server administrator. This would help alleviate 
the user bootstrapping problem

Original issue reported on code.google.com by david.ba...@gmail.com on 5 Aug 2013 at 5:32

GoogleCodeExporter commented 9 years ago
If your user account in SQL Server has been granted the server role of SysAdmin 
then your account is treated the same way the 'sa' account is by BioLink. This 
means you have full rights.

Original comment by david.ba...@gmail.com on 5 Aug 2013 at 5:34