Hi,
We are using SQL server authentication. Currently we have one account (dac) with reader writer permissions and this is used to connect to the database. We have another account onr which is database owner. We used full qualified names to access the database objects like onr.tbUser.
Now we want to move to Windows Authentication. We could setup an windows account with appropriate permissions to connect to the database but how could we handle the custom Owner with minimal changes. I mean if we remove the owner from the database then Is there any way to handle that using Windows Authentication OR Is it possible to use owner other than dbo with Windows Authentication
Thank you
...
Go to the complete details ...