Re: Change schema owner

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@xxxxxxxxxxxxxxxxxxxxxxx
I 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



.

Relevant Pages

  • Re: DBO Schema
    ... Because the questions are posted on the security forum, ... Using different schemas owned by different principals helps you separate ... give each subsystem its own namespace. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.security)
  • Re: How to use SQL Server Express
    ... I had never heard of SQL Server Management Studio Express before - but there you go! ... have experience with MySQL though, ... so I can create a database and start writing test db schemas to test ...
    (microsoft.public.sqlserver)
  • Re: Confusion about schemas, roles and .dbo
    ... if schemas were an integral part of managing database access, ... expecting to find some sort of GUI support for managing objects within ... and then use Roles to provide security to ...
    (microsoft.public.sqlserver.security)
  • Re: Granting Permissions to Roles in SQL Server 2005
    ... managing and viewing security. ... also working with SQL Server 2005. ... In Management Studio granting permissions to ... Schema.ObjectName, or just ObjectName in all of our code. ...
    (microsoft.public.sqlserver.security)
  • Re: Granting Permissions to Roles in SQL Server 2005
    ... Schema.ObjectName, or just ObjectName in all of our code. ... No one forces you to use schemas. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.security)