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!
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.
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.
