Database Integration
Oracle Integration
ID-Synch® can bind to any Oracle Database server (any version) using SQL*Net and issue PLSQL commands to enumerate users (SELECT), validate current passwords (test bind or SELECT) and reset passwords (ALTER USER, UPDATE or invoke a stored procedure).
The ID-Synch administrator can specify alternate SQL commands, and so can manage application passwords as well as database connect passwords.
ID-Synch can create, delete, enable, disable, modify and rename system users in any specified Oracle Database server. It creates new Oracle users by cloning existing ones, copying and adjusting their role memberships and tablespace rights in the process. It can also manage the membership of Oracle Database users in Oracle Database roles.
Oracle DBMS security roles are mapped to ID-Synch managed groups. ID-Synch can manage role assignment, using the its built in group-membership-management semantics.
The same ID-Synch agent that manages Oracle Database users can be configured with target-specific SQL code, in order to manage users defined wholly inside an application tablespace, rather than as database-level users. All the same operations (create, delete, enable, disable, rename, change attribute, change group membership) are supported in this configuration.
Sybase ASE Integration
ID-Synch can bind to any Sybase ASE database server (any version) using TDS and issue SQL commands to enumerate users (SELECT), validate current passwords (test bind or SELECT) and reset passwords (sp_password, UPDATE or invoke a stored procedure).
The ID-Synch administrator can specify alternate SQL commands, and so can manage application passwords as well as database connect passwords.
ID-Synch can create, delete, enable, disable, modify and rename system users in any specified Sybase ASE database server. It creates new Sybase ASE users by cloning existing ones, copying and adjusting their group memberships and tablespace rights in the process. It can also manage the membership of Sybase ASE database users in Sybase ASE database groups.
The same ID-Synch agent that manages Sybase ASE database users can be configured with target-specific SQL code, in order to manage users defined wholly inside an application tablespace, rather than as database-level users. All the same operations (create, delete, enable, disable, rename, change attribute, change group membership) are supported in this configuration.
SQL Server Integration
ID-Synch can bind to an MSSQL server, running version 7.x, 2000 or later, using its native TDS protocol. Once connected, ID-Synch can list users, validate current passwords and administratively reset passwords by issuing SQL commands and/or calling stored procedures (SELECT, SP_PASSWORD, UPDATE, etc.).
Default SQL commands are included to update MSSQL user passwords, while ID-Synch administrators may specify alternate commands to manage passwords in application tablespaces.
No agent software is installed on the SQL server.
ID-Synch can create, delete, enable, disable, modify and rename system users in any specified MSSQL server. It creates new MSSQL users by cloning existing ones, copying and adjusting their group memberships and tablespace rights in the process. It can also directly manage the membership of MSSQL users in MSSQL groups.
The same ID-Synch agent that manages MSSQL users can be configured with target-specific SQL code, in order to manage users defined wholly inside an application tablespace, rather than as database-level users. All the same operations (create, delete, enable, disable, rename, change attribute, change group membership) are supported in this configuration.
IBM UDB/DB2 Integration
ID-Synch can bind to any DB2/UDB database server (any version) using the DB2/UDB client software and issue SQL commands to enumerate users (SELECT), validate current passwords (test bind or SELECT) and reset passwords (UPDATE or stored procedure).
The ID-Synch administrator can specify alternate SQL commands, and so can manage application passwords as well as database connect passwords. ID-Synch can create, delete, enable, disable, modify and rename system users in any specified DB2/UDB database server. It creates new DB2/UDB users by cloning existing ones, copying and adjusting their group memberships and tablespace rights in the process. It can also manage the membership of DB2/UDB database users in DB2/UDB database groups.
The same ID-Synch agent that manages DB2/UDB database users can be configured with target-specific SQL code, in order to manage users defined wholly inside an application tablespace, rather than as database-level users. All the same operations (create, delete, enable, disable, rename, change attribute, change group membership) are supported in this configuration.