Highlighted
Absent Member.. Absent Member..
Absent Member..
1179 views

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

Tags (2)
0 Likes
2 Replies
Highlighted
Micro Focus Expert
Micro Focus 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
0 Likes
Highlighted
Acclaimed Contributor.. Acclaimed Contributor..
Acclaimed Contributor..

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
Click the Like button at the bottom to say 'Thanks'.
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.