Find Answers

Filter Search Results
All Operating Systems:
All Products:
All Solution Types:
Source:
 
Ask a Question
Example: "Database could not be verified"  
Tips | Start Over | Solutions | Alerts | Patches | Defects  
Pages [Next]
  Results
CMS-XML Dim10: Error: you do not have sufficient database privileges to manage Dimensions base databases
When user is trying to run CRDB, DLDB, or a number of other DMDBA commands, it returns the following error: Error: you do not have sufficient database privileges to manage Dimensions base databases Error: Only the Dimensions DBA can .....<perform the specified action>
CMS-XML Dim12: DMDBA and SQLServer: Running EXPM gets error - you do not have sufficient database privileges
This error can occur if the dmsys user within SQL Server does not have the appropriate roles. The dmsys user will need to have the sysadmin role in order to perform various functions within DMDBA. In some cases, this role is removed due to security constraints.
CMS-XML Dim14.4: DMDBA: SQL Server: Error: You do not have sufficient database privileges to manage Dimensions base databases.
The above error occurs because the access privileges for the basedatabase and/or pcms_sys user have been changed in Dimensions CM 14.4. When logging into DMDBA and using SQL Server as the basedatabase, you will want to log in similar to the following: DMDBA -ea dbo@<DSN >
CMS-XML DIM10: User attempts to add action description and gets error: COR0005526E: Unknown '618' privilege
The definition for this privilege is added to the database as part of the schema upgrade. If the database schema has not been upgraded to Dimensions 10.1.3 then this error may occur. To correct the problem, please upgrade the schema with the following:
CMS-XML KM-Dim9: When trying to run statistics through DMDBA, an error of 'You are not connected to a Dimensions Database' occurs or 'Error: You do not have the necessary privileges for this command' occurs.
For Dimensions 8.x and 9.1.x: When trying to run statistics through DMDBA, an error of 'You are not connected to a Dimensions Database' occurs or 'Error: You do not have the necessary privileges for this command' occurs. The above errors occur when logged into DMDBA as the system user or the basedatabase user .
CMS-XML DimCM: AdminConsole: What are the AdminConsole privileges which will allow users to log into Admin Console?
ADMIN_IDMTOOLMAN Database options ADMIN_UPDATE_DBOPTIONS
CMS-XML KM-Dim8: Problems with DMDBA where DB users are defined "externally"
Running DMDBA and performing database related operations you see the error: BASEDB> statistics compute Error: You do not have the necessary privileges for this command.
CMS-XML Dim10: Displaying Privileges in 'Show User Roles and Privileges' takes 90s - 120s
Using a very large Base Databases , it can take 90 - 120 seconds to display User Roles and Privileges when right-clicking on an item in Desktop Client.
CMS-XML KM-Dim10: Reported Defect DEF105954: Issue Fixed in Dimensions 10.1.1: Users with PRODUCT-MANAGER role have the same reported privileges in all product
When a user has PRODUCT-MANAGER role in any product in a base database , then the privileges for that user in all products are shown as being "allowed", even though the correct privileges are enforced.
CMS-XML KM-Dim9: 'Error: you do not have sufficient database privileges to manage Dimensions base databases. Only the Tool Manager can delete the views.' occurs when using dmdba to install, grant privileges, or delete views
In order to manage Dimensions base databases , you need to be logged into DMDBA as the Oracle system user account.
Pages [Next]

Welcome kb sso

My Recent Searches

Search Feedback

Are we answering your questions?

Additional Assistance

  • Submit a Case Online
  • FAQs