Have Geek Brain

How do I prevent Sysadmin users from accessing SQL Server?

I created a test user that has sysadmin right in SQL Server 2005 (sysadmin because I want to profile that username as well). But I want to restrict access to these user tests to the rights of the production database.

Under "logins" and also the db name selected on the User Mapping tab of its properties using the default "db_denydatareader" schema. But it can still run select commands.

+1


a source to share


1 answer


Sorry, but as soon as you grant SysAdmin access, you've given up the farm. You will have to create a different role for the test user and then grant access to only the databases that you want.



+2


a source






More articles:


All Articles