How to alter authorization when inloading an assembly

Coreysan 1,586 Reputation points
2023-07-14T00:48:43.4733333+00:00

I wrote an assembly in C# to place inside a SQL Server database. However, after all that work I found out I

don't own the database. An outsourced contractor does.

its unexpected since I created the DB, but now he owns it somehow.

I have full control just like he does, but I don't think I can alter the assembly authorization.

Or can I?

NOTE: I ran "alter authorization" and it ran without error, but the owner didn't change.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,301 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 39,181 Reputation points
    2023-07-14T05:36:25.33+00:00

    don't own the database. An outsourced contractor does.
    Or can I?

    Test it and you see it. Or as the DBA to do it for you.

    0 comments No comments

  2. Erland Sommarskog 99,296 Reputation points MVP
    2023-07-14T08:00:44.1133333+00:00

    What do you want to change the ownership of? The database or the assembly? This is not clear. Any why do you want to change it?

    Ideally, a database should be owned by an SQL login which exists solely to own that database and which has been granted no permissions.

    0 comments No comments