Anonymous_User Absent Member.
Absent Member.
956 views

MSSQL 2005 questions

Hi..

We are setting up ZCM using a MSSQL 2005 database, and in that regard I have
some questions about the required right to the database user.

We are using a specific SQL user with all right to the ZCM database, but the
user is not assigned any server roles. We have to give him the sysadmin
serverrole for login to work. Is that work by design ?
What is the minimum right for a database user ?

Best regards

Tue Nørgaard


Labels (2)
0 Likes
1 Reply
Anonymous_User Absent Member.
Absent Member.

Re: MSSQL 2005 questions

>
> We are setting up ZCM using a MSSQL 2005 database, and in that regard I
> have some questions about the required right to the database user.
>
> We are using a specific SQL user with all right to the ZCM database, but
> the user is not assigned any server roles. We have to give him the
> sysadmin serverrole for login to work. Is that work by design ?
> What is the minimum right for a database user ?


We found that giving the user db_owner and public is enough.

Be care with giving him other roles for the database.

We granted sysadmin rights during installation.

Best regards

Tue Nørgaard


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.