Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 2 replies
  • Subscribers 5 subscribers
  • Views 5159 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

SQL INSERT UMA_USER_ID?

SpoonMan

Alright,

I have just been tasked with putting together a script so we can automate adding techies to computers which have SafeGuard on them.

To do this I need to do an INSERT INTO usr_machine_assign.UMA_USER_ID which matches the ID of particular users from the safe_guard_dir table.

Just wondering if anyone else has done this and has any tips on how I should go about it?

Cheers

Dan

:41507


This thread was automatically locked due to age.
Parents
  • 0

    Hi SpoonMan,

    we wouldn't recommend this method as - besides other side effects - the table hashes would be corrupted when running inserts from SQL against the directly.

    As of SafeGuard Enterprise version 5.60, there is a feature called POA Users or POA Accounts (accounts for administrative access of machines) that should cover your needs. The SafeGuard Enterprise Administrators Manual (sgn_60_h_eng_admin_help.pdf) explains the feature and how to use it in detail. Please find the introduction excerpt below:

    "15 POA users for POA logon

    After SafeGuard Enterprise has been installed and the Power-on Authentication (POA) has been activated, access to endpoint computers to perform administrative tasks may be required. With POA users, users (for example members of the IT team) can log on at the Power-on Authentication on endpoint computers for administrative tasks without having to initiate a Challenge/Response procedure. There is no automatic logon to Windows. The users logging on with POA user accounts log on to Windows with their existing Windows accounts.

    You can create POA users, group them into POA groups and assign groups to endpoint computers. The users, this means the POA users, included in the POA group, are added to the POA and can log on using their predefined user name and password.

    Note: To manage POA users and POA groups you need Full access rights for the POA node under Users and Computers."

    Regards,

    Chris

    :41545
Reply
  • 0

    Hi SpoonMan,

    we wouldn't recommend this method as - besides other side effects - the table hashes would be corrupted when running inserts from SQL against the directly.

    As of SafeGuard Enterprise version 5.60, there is a feature called POA Users or POA Accounts (accounts for administrative access of machines) that should cover your needs. The SafeGuard Enterprise Administrators Manual (sgn_60_h_eng_admin_help.pdf) explains the feature and how to use it in detail. Please find the introduction excerpt below:

    "15 POA users for POA logon

    After SafeGuard Enterprise has been installed and the Power-on Authentication (POA) has been activated, access to endpoint computers to perform administrative tasks may be required. With POA users, users (for example members of the IT team) can log on at the Power-on Authentication on endpoint computers for administrative tasks without having to initiate a Challenge/Response procedure. There is no automatic logon to Windows. The users logging on with POA user accounts log on to Windows with their existing Windows accounts.

    You can create POA users, group them into POA groups and assign groups to endpoint computers. The users, this means the POA users, included in the POA group, are added to the POA and can log on using their predefined user name and password.

    Note: To manage POA users and POA groups you need Full access rights for the POA node under Users and Computers."

    Regards,

    Chris

    :41545
Children
No Data
Unfiltered HTML