Post reply

owned schema in a database user in security

  • August 10, 2010 at 2:46 am

    #238645

    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.

  • August 10, 2010 at 2:57 am

    #1204567

    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.

  • August 10, 2010 at 3:35 am

    #1204587

    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