Re: Change schema owner
- From: "Dan Guzman" <guzmanda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 10 Apr 2008 06:54:59 -0500
I'm sorry, I found the schemas under the security in the SQL server management studio and there it was simple to change
It is also simple to change the schema owner using Transact-SQL with ALTER AUTHORIZATION. For example
ALTER AUTHORIZATION ON SCHEMA::SomeSchema TO dbo;
--
Hope this helps.
Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/
"jonte@xxxxxxx" <jonasberthelsson@xxxxxxxxxxx> wrote in message news:ucUMXwtmIHA.1280@xxxxxxxxxxxxxxxxxxxxxxx
I'm sorry, I found the schemas under the security in the SQL server management studio and there it was simple to change
\\Jonas B
"jonte@xxxxxxx" <jonasberthelsson@xxxxxxxxxxx> skrev i meddelandet news:%23zsN4ltmIHA.3400@xxxxxxxxxxxxxxxxxxxxxxxI have a database with a user who owns schemas, so I can't drop the user and I am not allowed to drop the associated login because it's used in another database.
First I want to list all schemas for that user which he own but I havn't found how because when you are to change schema owner you must name the schema !?
I have changed DBO to another user.
I have read a little about it but I'm still confused.
Could you help me out ?
Sincerely
\\Jonas B
.
- References:
- Change schema owner
- From: jonte@xxxxxxx
- Re: Change schema owner
- From: jonte@xxxxxxx
- Change schema owner
- Prev by Date: Re: Change schema owner
- Next by Date: linked server : read only
- Previous by thread: Re: Change schema owner
- Next by thread: linked server : read only
- Index(es):
Relevant Pages
|
