mikrosc Absent Member.
Absent Member.
1560 views

SYBASE user rights to modify datatbase content

Hi, I'm new with ZCM11.

My need is to update Serial Number and Asset Tag for computers, which has not written these numbers in BIOS memory.
ZCM Inventory doesn't let to edit them.

I tried to define triggers or modify any NC_WORKSTATION table content with ODBC but "zenadmin" cannot do it.
The error is:
08001(-98)[Sybase][ODBC Driver][SQL Anywhere]Authentication violation
The only user I found is "zenadmin", but this user has no rights to modify database content.

How to set proper rights to the user?
Or there is another user with rights to write/modify?

Or there is another way to modify these serial or asset tag numbers in ZCM?
Labels (2)
0 Likes
2 Replies
Micro Focus Expert
Micro Focus Expert

Re: SYBASE user rights to modify datatbase content

The OEM Licensing of the Sybase Database is the reason for that error.
The ZCM code contains the licensing details to allow for the connection.
This is why your ODBC calls are not working.

DBISQL can be used to update the tables, but i'm not sure of a remote
way like ODBC without knowing how to get past the license restriction on
Sybase.


On 6/27/2011 1:06 PM, mikrosc wrote:
>
> Hi, I'm new with ZCM11.
>
> My need is to update Serial Number and Asset Tag for computers, which
> has not written these numbers in BIOS memory.
> ZCM Inventory doesn't let to edit them.
>
> I tried to define triggers or modify any NC_WORKSTATION table content
> with ODBC but "zenadmin" cannot do it.
> The error is:
> 08001(-98)[Sybase][ODBC Driver][SQL Anywhere]Authentication violation
> The only user I found is "zenadmin", but this user has no rights to
> modify database content.
>
> How to set proper rights to the user?
> Or there is another user with rights to write/modify?
>
> Or there is another way to modify these serial or asset tag numbers in
> ZCM?
>
>



--
Craig Wilson - MCNE, MCSE, CCNA
Novell Knowledge Partner

Novell does not officially monitor these forums.

Suggestions/Opinions/Statements made by me are solely my own.
These thoughts may not be shared by either Novell or any rational human.
0 Likes
mikrosc Absent Member.
Absent Member.

Re: SYBASE user rights to modify datatbase content

Thanks for reply, and suggestions.
It seems, that SYBASE verifies the application.
I downloaded SYBASE Central 10 (trial) and with ODBC connection i defined trigger on NC_WORKSTATION table..
Now I can write Serial NUmber or Asset Tag in Adminitrator defined fields (ADF10, ADF11) ad trigger writes this nimbers to SerialNumber and AssteTag fields BEFORE UPDATE.
Thanks for help.
------------------
Aleksander Krawiec
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.