owned schema in a database user in security

  • Hi all

    I am using SQL Server mgmt studio with 2005 db. I accidentally clicked the

    owned schema while in a database user in security. When I went back to

    remove the check boxes they were greyed out. How do I remove them?

    Thanks.

  • If you are sysadmin assign some other user you wish (or default dbo), the ownership of schema by checking owned schema checkbox of that particular schema for that particular user in the User Properties window.

  • Thanks for replay.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply