Post reply

Login is a dbowner of the database but not shown up as a user of the database

  • April 19, 2017 at 11:04 am

    #324491

    We have a tech that need to install a vendor product tool , but the database need to be on one of the SQL servers.
    So I granted the permission of the service account the application going to use, give it db creator role. And it is supposed to be the db owner of its own db after the tool install.

    After intall everthing OK, I see the login is the dbowner of the database in Login properties,  but I cannot see it listed in the users in the database, what do I miss?

    Thanks

  • April 19, 2017 at 11:20 am

    #1938890

    Its owner name is likely 'dbo'.  The actual owner of the db has the user name 'dbo', even though the login name is different.  Remember, SQL doesn't require the login and user names to be the same, even though most people do match them up to make it easier.

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

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

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