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 Dim: How to manually create Oracle user PCMS_SYS and what Oracle privileges are required
To check for the presence of the PCMS_SYS user type the following commands: $ sqlplus system /<system_password>@<dsn> SQL> select * from all_users where username = 'PCMS_SYS';
CMS-XML KM-Dim9: Installing Dimensions schema using non-system account - What Oracle minimum roles required?
||privilege|| ' to < user >; from
CMS-XML Minimum privileges required for the Oracle user connecting to an SBM schema
GRANT "CTXAPP" TO <USER_NAME> ; (see note below) SYSTEM PRIVILEGES: GRANT CREATE INDEXTYPE TO <USER_NAME> ;
CMS-XML Dim: Install: When installing Dimensions CM and it asks for the Oracle system user password, is this password stored anywhere?
Dim: Install: When installing Dimensions CM and it asks for the Oracle system user password, is this password stored anywhere?
CMS-XML KM-Dim10: When user trying to apply patch, the Oracle System account has been locked ORA-2800: the account is locked.
When user trying to apply patch, the Oracle System account has been locked ORA -2800 : the account is locked.
CMS-XML 10.x / 2009Rx / 12.x : dmdba statistics compute => DBA2800067E Error: Operation not allowed. Ensure user 'INTERMEDIATE' has the DBA role or all of the required privleges
Connected to system @dim12 ( oracle ) SYSTEM> connect to intermediate/intermediate@dim12 Connected to intermediate@dim12 (oracle)
CMS-XML Dim CM: CREATE ANY PROCEDURE and DROP ANY PROCEDURE privileges required to run "upgrade all"
The System Administration Guide contains a section called " Oracle Privileges Required for DMDBA Commands" where you can find a list of privileges that need to be assigned to an Oracle user if you are not going to be using the SYSTEM account for DMDBA operations. Unfortunately even with this list of privileges assigned the "upgrade all /force" command fails with the following message:
CMS-XML 10.1.x / Oracle 10g : why requiring to set UNDO_MANAGEMENT to MANUAL ?
user is in the process to migrate from Dimensions 8 to 10.
CMS-XML Minimum privileges required for the Microsoft SQL user to the SBM database
What are the minimal set of Microsoft SQL permissions the database user needs in order to be able to do all one needs for the end users of SBM? For information about Oracle permissions, see KB S133641 .
CMS-XML Creating an Oracle system DSN on 10.2.x and getting an error - sqlstate=im004
sql_handle_env failed" then it is likely you have not set up some required permissions as detailed on resolution. If you have a metalink acount you can reference
Pages [Next]

Welcome kb sso

My Recent Searches

Search Feedback

Are we answering your questions?

Additional Assistance

  • Submit a Case Online
  • FAQs