[Microsoft][ODBC SQL Server Driver][SQL Server]The database principal owns a schema in the database, and cannot be dropped.*/
Note A schema is not used for all Microsoft Dynamics GP users.
- On the computer that is running SQL Server 2005 or SQL Server 2008, click Start, point to Programs, point to Microsoft SQL Server 2005 or Microsoft SQL Server 2008, and then click SQL Server Management Studio.
- Log on to SQL Server by using the sa user name together with the corresponding password.
- On the File menu, point to New, and then click Database Engine Query.
- Download the MassDropUserSchemas.sql script. To do this, visit the following Microsoft Web site:
- Paste the contents of the script into a blank query window.
- On the Query menu, click Execute.
- Log on to Microsoft Dynamics GP.
- Use the appropriate method:
- In Microsoft Dynamics GP 10.0 and in Microsoft Dynamics GP 2010, point to Tools on the Microsoft Dynamics GP menu, point to Setup, point to System, and then click User Access.
- In Microsoft Dynamics GP 9.0, point to Setup on the Tools menu, point to System, and then click User Access.
- Grant the user access to a Microsoft Dynamics GP company. Or, remove the user access from the Microsoft Dynamics GP company.
If the same error occurs, there could one or more schemas that are owned by that user. Follow these steps to verify that the user does not own another schema:
- Log into the SQL Server Management Studio. To do this, follow the steps one and two of the previous process.
- In the Object Explorer window, expand Databases, expand <Database name>, expand Security, and expand Users.
- Right-click on the user and then click Properties.
- On the first page that appears there are two boxes with items. that can be selected. The items are labeled as Schemas owned by this user and Database role membership. Note the name of the squema.
- Click Cancel to close the Properties window.
- In the Object Explorer pane, collapse the Users folder and expand the Schemas folder.
- Right-click on the schema noted from step 4 and click Properties. The page Schema Properties-<SchemaName> should appear.
- Change the Schema Owner from the current user to the new user name. For example, if the schema name is DYNGRP and the owner is different, change the owner name to DYNGRP.
- Follow the steps 7-9 of the previous process to remove or give company access for a user.
Id. de artículo: 919723 - Última revisión: 14 jul. 2012 - Revisión: 1