Home > Cannot Use > Cannot Use The Reserved User Or Role Name Dbo

Cannot Use The Reserved User Or Role Name Dbo

Greg 0 LVL 1 Overall: Level 1 Message Author Comment by:Marty Block2009-10-23 Comment Utility Permalink(# a25644528) OK, this command: select name from sysobjects where uid=user_id("dbo") yields this result: Server: Msg The dbo user cannot be deleted and is always present in every database. There is a USER with the user name of DBO. All rights reserved.Terms of Use|Trademarks|Privacy Statement|Site Feedback Blog Sign in Join ASP.NET Home Get Started Learn Hosting Downloads Community Overview Community Spotlight Articles of the Day What's new Community Blogs ASP.NET http://homeshareware.com/cannot-use/cannot-use-the-special-principal-sa-user-mapping.html

Copyright © 2002-2016 Simple Talk Publishing. I checked the 'User Map' setup to the 'sa' account and the databases that need accessing aren't mapped.When I try to add the map, I get error "Cannot use the special You cannot delete other posts. All Forums SQL Server 2000 Forums SQL Server Development (2000) Error 15405: Cannot use the reserved user or role name dbo Reply to Topic Printer Friendly Author Topic AskSQLTeam Ask click site

more hot questions question feed lang-sql about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation In order to add db_securityadmin, you will need to change the owner of the database to an administrative account. regards, Nana Reply With Quote 07-10-2001,01:57 AM #2 Kurt Guest Error: 15405; Cannot use the reserved user or role name 'dbo' (reply) You are probably trying to drop the dbo role

Those should be single quotes like in the last example. Hope this helps. 0 Kudos Reply Contact Privacy Policy Terms & Conditions Home | Weblogs | Forums | SQL Server Links Search: Active Forum Topics | Popular Articles | All Articles but in the screenshot above, In the 'Name' column, (far left), there's a name 'Test4bob' and the 'Login Name' is 'test4bob'. (I created this). In effect, 'Domain\myname' a user, having a login, has been deleted.Now, to test my new permissions, from the SQL Server level, I add myself again, using the same domain\myname(as we are

If you don't want this, use sp_changedbowner to make someone else the DB owner. -- Erland Sommarskog, SQL Server MVP, es****@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx Books Online Join & Ask a Question Need Help in Real-Time? I'm not sure I described the problem well enough. Any other suggestions? 0 LVL 21 Overall: Level 21 MS SQL Server 12 Databases 7 Message Expert Comment by:JestersGrind2009-10-22 Comment Utility Permalink(# a25638670) Ok, that's a different problem.

Greg 0 LVL 1 Overall: Level 1 Message Author Comment by:Marty Block2009-10-23 Comment Utility Permalink(# a25644857) I grok that... SO what has happened, somehow, is that I have a USER NAME with te reserved word of 'dbo' ! Now you should be able to delete the user. DBO-user-Name-problem.jpg 0 LVL 21 Overall: Level 21 MS SQL Server 12 Databases 7 Message Expert Comment by:JestersGrind2009-10-22 Comment Utility Permalink(# a25638424) I understand.

I'm receiving the error above in slightly different circumstances. As you can see, I'm not, I'm attempting to remove it from my name.A brief history:All objects in this database have owner: dbo.ME, the previous Sysadmin, User Domain\myname was assigned dbo Using Database Access tab, I highlight a database. Join Now For immediate help use Live now!

You cannot edit other posts. You cannot post EmotIcons. When I try to grand db_datareader role to dbo, I get the following error [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot use the reserved user or role name 'db_datareader'. I found the the Database Access for SQL Server Login sa properties only public and db_owner checked.

As you are a sysadmin, you can still be in the group and you will have all the privileges on the system. db_securityadmin is required for the configuration databases. thank you. http://homeshareware.com/cannot-use/cannot-use-full-text-search-in-user-instance.html Microsoft SQL Server, Error: 15405 When importing a database in your SQL instance you would find yourself with Cannot use the special principal 'sa'.

You cannot edit HTML code. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.Would you like to participate? Those should be single quotes like in the last example.

share|improve this answer answered Mar 4 '13 at 19:50 user2120935 1 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign

Nor do they need to be. Developer does not see priority in git Development Workflow being followed Wrong way on a bike path? It's a built-in role that can only belong to one user in a database. When I tried to check those permissions this error.is displayedError 15405: Cannot use the reserved user or role name dboI am able to open the database and access it from Query

The first is 'Name', the second is 'Login Name', nd the last is 'Database Access'. Problem in solving this book and pages question How to be Recommended to be a Sitecore MVP How can I ask about the "winner" of an ongoing match? then change the owner under files to sa then you can map it under Logins . This will drop and clear the anamolies in the user-login conflicts.

Get 1:1 Help Now Advertise Here Enjoyed your answer? We've restricted the ability to create new threads on these forums. Veritas.com Support Veritas Open Exchange Login or Join Communities Information Governance Backup and Recovery Business Continuity Partners Inside Veritas Vision 2016 Developers Blogs Groups Vision 2016 Veritas.com Support Communities Information Governance E.g. "EnterriseValutAccess" or "EVAccess". 0 Kudos Reply Re: maj_rif Level 4 ‎08-05-2009 02:23 AM Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Highlight Print Email to a Friend Report

Display field value in Drop Link field Are there continuous functions for which the epsilon-delta property doesn't hold? The solution takes some of out-of-the-box thinking; read on! .NET Programming C# Databases Introduction to SQL Command Tool in Oracle APEX Article by: Swadhin SQL Command Tool comes with APEX under

Back to Top