Share via

How to alter authorization when inloading an assembly

Coreysan 1,786 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.
14,318 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 45,626 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
  2. Erland Sommarskog 115.6K 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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.