topic Re: How can DBO test other users in OS Auth SQL Server? in Data Management Questions

How can DBO test other users in OS Auth SQL Server?

Anonymous User — Fri, 22 Mar 2013 15:09:45 GMT

Hello! We're using SQL Server OS Auth, and I am DBO. How can I mimic/test another users' experience? When we were on DB Auth in Oracle, it was simple--just access the tables using the user's logon and password. But OS Auth disallows this. I can't test as a regular user, because I am always DBO. What is the workaround?
Thank you!

Re: How can DBO test other users in OS Auth SQL Server?

MarcoBoeringa — Tue, 26 Mar 2013 11:58:00 GMT

Your IT network administrators may not like it, but the only logical thing to do is to create a second OS account with "normal" user priviliges, instead of DBO, used for testing purposes. This account should not be coupled with a physical person, so that you can use it using the credentials of the account.

The whole purpose of being DBO is to be able to manage your (geo-)database. Changing the DBO account properties is therefore not a real option.

If your network administrators really don't allow it, or if you have a host of different specific permissions set for multiple users, than I guess one generic account won't do, and I guess being good friends with your non-DBO colleagues, is a must... or a switch over to "mixed mode authentication" with your SQL Server instance.

Re: How can DBO test other users in OS Auth SQL Server?

Anonymous User — Tue, 26 Mar 2013 19:00:29 GMT

Thank you for the reply; we did end up pursuing that exact outcome, and, believe it or not: the IT group happily complied! Thanks again.