HP-OVE-USER and HP-OVE-Deleg-User require db_owner rights

  • KM00650786
  • 14-Nov-2013
  • 14-Nov-2013

Summary

Are db_owner rights needed for HP-OVE-USER and HP-OVE-Deleg-User?

Question

Are db_owner rights needed for HP-OVE-USER and HP-OVE-Deleg-User?

Answer

It is a prerequisite to have ovms* users configured as db_owner for openview DB and we cannot guarantee the full functionality of the product in case the database user permissions are changed manually afterwards

The ovms_* users are created during the installation using the following SQL commands (see also: C:\Program Files\HP\HP BTO Software\lbin\OvOW\ServerConsoleInstall\dbscripts\create_WinAuthUser.sql) :


exec sp_executesql N'IF NOT EXISTS (SELECT * FROM sys.server_principals WHERE name LIKE ''<DOMAIN\HP-OVE-User>''
AND type=''U'') CREATE LOGIN [<DOMAIN\HP-OVE-USER>] FROM WINDOWS WITH DEFAULT_DATABASE = openview'
exec sp_executesql N'CREATE USER ovms_adm FOR LOGIN [<DOMAIN\HP-OVE-USER>] WITH DEFAULT_SCHEMA = ovms_adm'
exec sp_addrolemember 'db_owner', 'ovms_adm'
exec sp_executesql N'IF NOT EXISTS (SELECT * FROM sys.server_principals WHERE name LIKE ''<DOMAIN\HP-OVE-Deleg-User>''
AND type=''U'') CREATE LOGIN [<DOMAIN\HP-OVE-Deleg-User>] FROM WINDOWS WITH DEFAULT_DATABASE = openview'
exec sp_executesql N'CREATE USER ovms_deleg FOR LOGIN [<DOMAIN\HP-OVE-Deleg-User>] WITH DEFAULT_SCHEMA = ovms_adm'
exec sp_addrolemember 'db_owner', 'ovms_deleg'


exec sp_executesql N'GRANT CONTROL ON SCHEMA :: ovms_adm TO ovms_adm'

exec sp_executesql N'GRANT CONTROL ON SCHEMA :: ovms_adm TO ovms_deleg'