UCMDB and UD Practitioners Forum (Previously CMS)
cancel

HP UCMDB 10.01 SQL server Database permission

Highlighted
BraveChen
Super Contributor

HP UCMDB 10.01 SQL server Database permission

Sorry that I can't find the ucmdb forum today, so I post the question here.

 

I would like to know if is necessary the db_ddladmin permission in the UCMDB Database (SQL Server 2008), because the Customer doesn’t allow use this permission.
What are the permissions the UCMDB uses after the database created?

In the DatabaseGuide.pdf manual has the permissions in the UCMDB database. I ‘m not sure if these permissions are only to create database or if after the database created I need to use the permissions below:


1. Log in to the Microsoft SQL Server Management Studio
with the user name you want to check.
2. Change the context of the database to the required
database.
3. Open a new query and do the following for each database:
select case when IS_MEMBER ('db_owner')=1
or IS_SRVROLEMEMBER ('sysadmin')=1
or (IS_MEMBER ('db_ddladmin') = 1 and
IS_MEMBER ('db_datareader')=1 and
IS_MEMBER ('db_datawriter')=1 and
IS_MEMBER ('db_denydatareader')=0 and
IS_MEMBER ('db_denydatawriter')=0
) then 'User has enough permissions'
else 'User does not have enough
permissions'
end

 

 

P.S. This thread has been moved from Application Perf Mgmt (BAC / BSM) Support and News Forum to CMS and Discovery Support and News Forum.
-HP Forum Moderator

2 REPLIES
PatWest
HPE Expert

Re: HP UCMDB 10.01 SQL server Database permission

hi,

You should post this in the uCDMB forum:

h30499.www3.hp.com/t5/uCMDB-Support-Customer-Forum/bd-p/ucmdb-support-customer-forum
Dima Gomel
HPE Expert

Re: HP UCMDB 10.01 SQL server Database permission

Hi,

Unfortunately, the DB guide is very clear about permissions needed for UCMDB. Please be advised that  UCMDB lyfecycle includes upgrades for dat and meta-data. Running of Data Defeinition Language commands is needed.

Regards
-Dmitry Gomel, PMP
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
Click the Like button at the bottom to say 'Thanks'.
//Add this to "OnDomLoad" event