But be sure that, you have a system Administrator login, before removing this built in login. Cordially, RN Thursday, March 22, 2012 1:10 PM Reply | Quote 0 Sign in to vote Thanks carolinee, big help.. You cannot edit other topics. Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing. check my site
You can use that account just for dbo roles. You cannot delete your own posts. Home | Weblogs | Forums | SQL Server Links Search: Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About Please start any new
one more question: can i revoke the db_owner permission from BUILTINadministrators and assign it the datareader permission? Is it possible to bleed brakes without using floor jack? Now I can finally see the relationships between the tables. Cannot Alter The User Dbo xuka200308 New Member Hi All we revoke the 'sa' permission from BUILTIN/administrators account.
Advanced Search Forum Database Discussions MS SQL Server 7/MS SQL Server 2000 Error: 15405; Cannot use the reserved user or role name 'dbo' If this is your first visit, be sure Cannot Use The Special Principal 'dbo' Sharepoint But you can try deleting 'BUILTINAdministrators' login and add it back... exec sp-revokelogin 'BUILTINAdministrators' exec sp-grantlogin 'BUILTINAdministrators' Mohammed U. http://www.sqlservercentral.com/Forums/Topic377412-92-1.aspx Mohammed U.
SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Login Failed For User Sa Heuristic algorithms for the dense assignment problem Why had Dumbledore accepted Lupin's resignation? You cannot delete other topics. Members Members Quick Links Registered Members Current Visitors Recent Activity Help Help Quick Links Smilies BB Codes Trophies Search titles only Posted by Member: Separate names with a comma.
Any one of you can share the same for SQL 2000 SP4. Check This Out right now we found that BUILTIN/administrators doesn't have db_owner permission or ddladmin permission on 2 databases. However, I ran sp_changedbowner anyway just as a test and it removed his alias'. You cannot upload attachments. Cannot Drop The User 'dbo'.
Post #377585 SQLKnightSQLKnight Posted Friday, June 29, 2007 5:34 AM Grasshopper Group: General Forum Members Last Login: Monday, June 29, 2015 4:25 PM Points: 12, Visits: 74 Try running orphan user Strange but thank you so much! You may read topics. Source please advise.
thanks again. Sp_changedbowner I am trying to add sa to several databases created by other users than sa. The properties of the database did NOT have him as the owner.
You may download attachments. You cannot delete other events. ThanksLaurentiu Thursday, September 14, 2006 10:07 PM Reply | Quote Moderator 0 Sign in to vote I have fixed this already, thanks though.The problem was that the db owner was the Sp_changedbowner 'sa' You may have to register before you can post: click the register link above to proceed.
Coming to your question: Posted - 12/01/2006 : 12:55:47 -------------------------------------------------------------------------------- one more question: can i revoke the db_owner permission from BUILTINadministrators and assign it the datareader permission? think you might benefit from a good read of BOL or a suitable training course! I cannot drop the db_owner permissions that he has on the database because I get the error "Error 15405: Cannot use the reserved user or role name 'dbo'." How do I http://knowaretech.com/cannot-use/15405-cannot-use.html Obviously this person is the owner of the database.
You cannot post new polls. Type: USE mydatabase exec sp_changedbowner 'sa', 'true' Close the new query and after viewing the security of the sa, you will find that that sa is the DBO of the database. Thanks anyway Friday, February 16, 2007 7:58 AM Reply | Quote 3 Sign in to vote Hey, I find out how to change it using Management Stadio Express: Right click the regards, Nana Reply With Quote Quick Navigation MS SQL Server 7/MS SQL Server 2000 Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Database Discussions IBM
Related 1020Insert results of a stored procedure into a temporary table74The EXECUTE permission was denied on the object 'xxxxxxx', database 'zzzzzzz', schema 'dbo'0about dbo schema1Attaching databases results in error “The server Your name or email address: Do you already have an account? I do not want him to have dbo permissions. If they're the DB owner, they already have permission to do anything they want to within this database. (To see the owner of the database, open the properties of the database.
If you're still getting this error, then you're not connecting to the database you think you are, but since you've not shown any screenshots of the actual point where you supply Results 1 to 2 of 2 Thread: Error: 15405; Cannot use the reserved user or role name 'dbo' Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Otherwise , you will have to re-install the Instance itself. Newer Than: Advanced search...
The time now is 08:29 PM. Recreate all the database objects with "dbo".-- Orphan user Security Fix:DECLARE @username varchar(25)DECLARE fixusers CURSOR FORSELECT UserName = name FROM sysusers WHERE issqluser = 1 and (sid is not null and Erland Sommarskog wrote: MK (firstname.lastname@example.org) writes: In the login properties on the Database Access tab, a user's name says dbo instead of his name. As you are a sysadmin, you can still be in the group and you will have all the privileges on the system.
thanks in advance, xuka200308, Nov 30, 2006 #2 MohammedU New Member I think it is db ownership issue... then change the owner under files to sa then you can map it under Logins . I want understand why you want to be a user again. I cannot drop the db_owner permissions that he has on the database because I get the error "Error 15405: Cannot use the reserved user or role name 'dbo'." How do I
I do not want him to have dbo permissions.