| |
Results |
|
How To: VM6.5: Restrict a User?s Privileges at the Project Database Level
|
A successful implementation of this scenario requires the maintenance of three separate Access Control Databases .
|
|
|
|
How To: VM6.5: Limiting Users' Privileges and Create Project Database.
|
specify an access control database that defines all the users that will be using PVCS Version Manager and the privileges they will have accross all project databases and projects. Then in the Allow/Disallow tab, you must disallow Access Contol Database
|
|
|
|
Find which users have the Remote Administration privilege
|
Run the following SQL query against the SBM database to get a list of all users with the "Remote Administration" privilege assigned to them. select u.TS_LOGINID, p.* from TS_PRIVILEGES p
|
|
|
|
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>
|
|
|
|
How to use readdb and makedb to add, change, or remove users, groups, and privileges
|
The process of updating the Access Control Database (ACDB) file by hand consists of 3 steps: Use readdb to export of the contents of the ACDB into a text file. readdb -p "PathToACDB
|
|
|
|
SQL Server Database Privileges
|
The SQL Server user needs the following permissions: Create, Alter, and Drop Tables. Create and Drop Indexes.
|
|
|
|
Deploy-locked TeamTrack database - users must only be edited through their web profile
|
This synchronisation can be checked like in this example: C:\Program Files\Serena\TeamTrack\bin>DeploymentTool.exe /loglevel 4 /sync /live "DSN=MyDB;UID=sa;PWD=sa" /test SN=MyDB_Dev;UID=sa;PWD=sa" The deployment log file will speak of mismatching lastIds either in NotificationSubscriptions or Privileges .
|
|
|
|
DimCM: AdminConsole: What are the AdminConsole privileges which will allow users to log into Admin Console?
|
ADMIN_IDMTOOLMAN Database options ADMIN_UPDATE_DBOPTIONS
|
|
|
|
Minimum privileges required for the Oracle user connecting to an SBM schema
|
Both of these can cause problems if your Oracle instance hosts multiple SBM schemas. For instance splitting your database between multiple schemas in Configurator.
|
|
|
|
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.
|
|
|
