June 22, 2026 at 12:00 am
Comments posted to this topic are about the item Changing the Schema
June 22, 2026 at 2:43 pm
It tried this script running it with a login with sysadmin permissions. I ran into several issues with the script. For example, SETUSER would fail because that requires specific dbowner permission. The login with sysadmin permissions shows as dbowner under Logins | User Mapping; however, the login does not show at all under Logins in the database. This is because the login with sysadmin resolves to dbo. I used EXECUTE AS instead of SETUSER.
I do understand that the intent of this quiz was to point out that the object level permissions behaviour changes with a schema ownership change in SQL Server 2022.
ewm2
June 22, 2026 at 4:27 pm
That's strange. My sysadmin worked fine. I suspect you might not have reverted after setuser. That often causes issues.
However, if you want to try and post the steps with results and repro, I'm happy to try and debug.
June 22, 2026 at 4:27 pm
That's strange. My sysadmin worked fine. I suspect you might not have reverted after setuser. That often causes issues.
However, if you want to try and post the steps with results and repro, I'm happy to try and debug.
June 22, 2026 at 4:27 pm
That's strange. My sysadmin worked fine. I suspect you might not have reverted after setuser. That often causes issues.
However, if you want to try and post the steps with results and repro, I'm happy to try and debug.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply