Native Error 2760
Contents |
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 2008 »
Sql Server The Specified Schema Name Either Does Not Exist Or You Do Not Have Permission To Use It
T-SQL (SS2K8) » grant permission help need - Error Msg 2760, grant permission msg 2760 sql server help need - Error Msg 2760, Rate Topic Display Mode Topic Options Author Message SQL GalaxySQL Galaxy Posted Wednesday, July 13, 2011 5:30 AM Ten Centuries Group: General Forum Members Last Login: Today @ 5:31 AM Points: 1,178, Visits: 3,450 Hi,Please give me suggestion, how to resolve this issue?--create Login script--use masterCREATE LOGIN test1 WITH PASSWORD = 'SMTStest_1';--use database name--create user scriptCREATE USER test1 FOR LOGIN test1 WITH DEFAULT_SCHEMA = dbo;GO--alter script to change which is assgin database this user.ALTER LOGIN [test1] WITH DEFAULT_DATABASE=[test]--Grant permissionGRANT CREATE TABLE TO [test1];create table test3 (id_clo int)Msg 2760, Level 16, State 1, Line 1The specified schema name "dbo" either does not exist or you do not have permission to use it. Post #1140893 bopeavybopeavy Posted Wednesday, July 13, 2011 5:39 AM SSC Eights! Group: General Forum Members Last Login: Friday, June 24, 2016 11:28 AM Points: 941, Visits: 690 Have you run down the obvious, like do you have the appropreate rights? Or You need to run under correct database and correct schema. "There are no problems! Only solutions that have yet to be discovered!" Post #1140896 SQL GalaxySQL Galaxy Posted Wednesday, July 13, 2011 5:45 AM Ten Centuries Group: General Forum Members Last Login: Today @ 5:31 AM Points: 1,178, Visits: 3,450 Yes, I have correct schema (dbo) and user name.1. Login - test1 with pw ( default db is test)2. query editor - USE database name3. create table - but till facing same error.rgdsananda Post #1140901 bopeavybopeavy Posted Wednesday, July 13, 2011 5:48 AM SSC Eights! Group: General Forum Members Last Login: Friday, June 24, 2016 11:28 AM Points: 941, Visits: 690 But do you have the permissions to use it? "There are no problems! Only solutions that have yet to be discovered!" Post #1140902 Abhijit MoreAbhijit More Posted Wednesday, July 13, 2011 5:51 AM SSC Eights! Group: General Forum Member
Error: 3701 [Microsoft][SQL Native Client][SQL Server] Cannot drop theview 'EBSGL20001V', because it does not exist or you do not have permission.SQL Error: 2760 [Microsoft][SQL Native Client][SQL Server] The specifiedschema name "dbo" either does not exist or you do not have permission to useit.Thank you in advance!Craig Mariano Gomez 2008-12-08 20:46:11 UTC PermalinkRaw Message You may want to run the GRANT.SQL utility script provided with MicrosoftDynamics GP on all your company and DYNAMICS databases.Best regards,--MG.-Mariano Gomez, MIS, MCP, PMPMaximum Global Business, LLChttp://www.maximumglobalbusiness.comThe http://www.sqlservercentral.com/Forums/Topic1140893-392-1.aspx Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.comPost by CraigI am seeing a series of error messages when users attempt to log in through aSQL Error: 3701 [Microsoft][SQL Native Client][SQL Server] Cannot drop theview 'EBSGL20001V', because it does not exist or you do not have permission.SQL Error: 2760 [Microsoft][SQL Native Client][SQL Server] The specifiedschema name "dbo" either does not exist or http://microsoft.public.greatplains.narkive.com/PBYldhWs/login-error-drop-view you do not have permission to useit.Thank you in advance!Craig Craig 2008-12-10 03:58:00 UTC PermalinkRaw Message It turns out a customization was trying to create a couple of tables and allI needed to do was log in as the 'sa'.Thanks though!CraigPost by Mariano GomezYou may want to run the GRANT.SQL utility script provided with MicrosoftDynamics GP on all your company and DYNAMICS databases.Best regards,--MG.-Mariano Gomez, MIS, MCP, PMPMaximum Global Business, LLChttp://www.maximumglobalbusiness.comThe Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.comPost by CraigI am seeing a series of error messages when users attempt to log in through aSQL Error: 3701 [Microsoft][SQL Native Client][SQL Server] Cannot drop theview 'EBSGL20001V', because it does not exist or you do not have permission.SQL Error: 2760 [Microsoft][SQL Native Client][SQL Server] The specifiedschema name "dbo" either does not exist or you do not have permission to useit.Thank you in advance!Craig 2 Replies 7 Views Switch to linear view Disable enhanced parsing Permalink to this page Thread Navigation Craig 2008-12-08 19:50:06 UTC Mariano Gomez 2008-12-08 20:46:11 UTC Craig 2008-12-10 03:58:00 UTC about - legalese Loading...
FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join Tek-Tips Forums! Talk With Other Members Be Notified Of ResponsesTo Your http://www.tek-tips.com/viewthread.cfm?qid=621216 Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! Join Us! *Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! Add sql server Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. FrontRange Solutions: GoldMine Forum at Tek-Tips HomeForumsEnterprise ApplicationsERP and CRM Solution VendorsFrontRange Solutions: GoldMine Forum Error Creating Sync Set thread868-621216 Forum Search FAQs Links MVPs Error Creating Sync Set Error Creating Sync Set native error 2760 bacmb (MIS) (OP) 4 Aug 03 12:01 Whenever we try to create a sync set on the server, or set connect via the network, we get an error on the server.GM goes through all of the DBNAME created, then gets to "Creating transfer file for GMBase tables".The next thing we get is a popup saying:General SQL error.Native SQL error 2760Context: CreateTableUsingQueryGoldMine_Sales_And_Marketing: V8442859GoldMine_Sales_And_Marketing: V84428591: Server message: Specified owner name'GoldMine_Sales_and_Marketing' either does not exist or you do not have permission to useBDE Error Cat: Code: [51:3]BDE 500[4/11/1999] GoldMine: 6.00.30403Does anyone have any idea what is going on here? I have no clue where an owner name of "GoldMine_Sales_and_Marketing' would come into the picture.Thanks!Chuck Brown RE: Error Creating Sync Set boxster87 (IS/IT--Management) 26 Aug 03 00:12 GoldMine is trying to create temporary tables to create the sync set and has insufficient rights in SQL for some reason. Did you recently migrate this database from another server or create a new database?That's usually when this error occurs.You should be able to fix it by deleting the SQL login name and recreating it.Per FrontRange, "