Professional Web Applications Themes

Problem creating objects not as dbo - Microsoft SQL / MS SQL Server

I have a problem with people logging on as one user, but sql server keeps changing the owner to dbo. Sometimes the owner name will be their loggin account and sometimes it will be dbo. Is there anyway to stop dbo from becoming the owner, it is really fouling things up. There are only two users in the database, so how do I keep dbo from owning anything. I never want anybody creating object as dbo.table....

  1. #1

    Default Problem creating objects not as dbo

    I have a problem with people logging on
    as one user, but sql server keeps
    changing the owner to dbo. Sometimes
    the owner name will be their loggin
    account and sometimes it will be dbo.
    Is there anyway to stop dbo from
    becoming the owner, it is really
    fouling things up.

    There are only two users in the database,
    so how do I keep dbo from owning anything.
    I never want anybody creating object as dbo.table.

    Philip Guest

  2. #2

    Default Re: Problem creating objects not as dbo

    If you want users to create only objects owned by their own userid,
    grant them CREATE statement privileges and remove them from the db_owner
    and db_ddladmin fixed database roles as well as the sysadmin server
    role.

    --
    Hope this helps.

    Dan Guzman
    SQL Server MVP

    -----------------------
    SQL FAQ links (courtesy Neil Pike):

    [url]http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800[/url]
    [url]http://www.sqlserverfaq.com[/url]
    [url]http://www.mssqlserver.com/faq[/url]
    -----------------------

    "Philip" <atec396hotmail.com> wrote in message
    news:013e01c347c9$76c75780$a301280aphx.gbl...
    > I have a problem with people logging on
    > as one user, but sql server keeps
    > changing the owner to dbo. Sometimes
    > the owner name will be their loggin
    > account and sometimes it will be dbo.
    > Is there anyway to stop dbo from
    > becoming the owner, it is really
    > fouling things up.
    >
    > There are only two users in the database,
    > so how do I keep dbo from owning anything.
    > I never want anybody creating object as dbo.table.
    >

    Dan Guzman Guest

Similar Threads

  1. Creating Acrobat objects with LotusScript
    By Mary_Escarraz@adobeforums.com in forum Adobe Acrobat SDK
    Replies: 0
    Last Post: September 15th, 07:52 PM
  2. DCOM Errors when creating COM Objects in IIS
    By Andy in forum ASP Components
    Replies: 8
    Last Post: March 14th, 01:51 PM
  3. Creating COM objects remotely
    By ltsakiris in forum Coldfusion - Advanced Techniques
    Replies: 0
    Last Post: July 27th, 12:05 AM
  4. Creating objects
    By brice in forum PERL Miscellaneous
    Replies: 3
    Last Post: September 23rd, 10:46 AM
  5. Handle leak when creating COM objects from ASP?
    By Adam Nachman in forum ASP Components
    Replies: 0
    Last Post: July 1st, 10:24 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139