Managing Oracle Clinical, RDC, and TMS User Accounts with Ease
5/1/2013
5/1/2013 Copyright © BioPharm Systems, Inc. 2012. All rights reserved
Welcome and Introduction
› Introduction
– Michelle Engler, Clinical Systems Developer
– With BioPharm Systems since1999
– Contact Information:
• (650) 291-4710
› Background
– Experience in Development, using many different languages: Perl, C++, PL/SQL, JavaScript, Oracle, AJAX technologies
– Well-versed in Oracle Clinical and Oracle Clinical technologies (including the Data Capture API)
– Background in System Design, FDA 21 CFR Part 11 Compliance, and Quality Assurance
Thank you for taking the time to attend this webinar!
Accel-Account Manager Overview
› What is Accel-Account Manager?
› What is a Clinical Account?
› New Account Request
› Password Reset
› Accel-Account Manager Features
› Installation and Technology Stack
› Demonstration
5/1/2013 Copyright © BioPharm Systems, Inc. 2012. All rights reserved
What is Accel-Account Manager?
5/1/2013 Copyright © BioPharm Systems, Inc. 2012. All rights reserved
Accel-Account Manager is a web-based system that facilitates the
management of clinical accounts for Oracle Clinical, Remote Data
Capture, and Thesaurus Management System.
What is a Clinical Account?
5/1/2013 Copyright © BioPharm Systems, Inc. 2006. All rights reserved 5
Database
Account
Database Roles
Password Profile
OC Study Access
RDC Study Site Access
Database Operating System
Account
Home Directory
Log Directory
Report Server
Account
Report Directory
SAS Server
Account
SAS Directory
Pro
du
ctio
n
Database
Account
Database Roles
Password Profile
OC Study Access
RDC Study Site Access
Database Operating System
Account
Home Directory
Log Directory
Report Server
Account
Report Directory
SAS Server
Account
SAS Directory
Test
Database
Account
Database Roles
Password Profile
OC Study Access
RDC Study Site Access
Database Operating System
Account
Home Directory
Log Directory
Report Server
Account
Report Directory
SAS Server
Account
SAS Directory Dev
elo
pm
ent
A Clinical Account consists of several coordinated accounts, directories,
and settings across multiple severs and databases.
5/1/2013 Copyright © BioPharm Systems, Inc. 2012. All rights reserved
5/1/2013 Copyright © BioPharm Systems, Inc. 2012. All rights reserved
New Account Request as it is Today
Great, I have a new account.
Thank you, all.
Great, I just received notice that
the new account has been
created. I will assign OC Study
Access and RDC Study Site
Access, now.
Dear Database Administrator, Will you please
create the database portions of this new account?
Dear IT Professional, Will you please create the IT
components of this new account?
Dear Support Representative, The database
components of the new account have been created.
May I have an account?
Dear End-User, Your new
account has been created.
I just received a request to create the IT components
of a new account. I will create them now.
Dear Support Representative, The IT components of
the new account have been created.
I just received a support ticket for creating a new
account, better notify the DBA and IT Professional.
Dear Manager, The new account has been created.
I just received a request to create the database
components of a new account. I will create them now.
Great, I heard back from both the IT Professional and
DBA that the account has been created.
Yes, I will log a support ticket
requesting an account
5/1/2013
New Account Request with Accel-Account Manager
May I have an account?
Automatic
Notification of
Credentials
Great, I have a new account.
I will set my password and
security questions.
Yes, I will create the account and
add OC Study/RDC Study Site
Access with Accel-Account
Manager.
Copyright © BioPharm Systems, Inc. 2012. All rights reserved
5/1/2013
Password Reset as it is Today
Oops! I forgot my password.
Will you reset my password?
I just received a support ticket for resetting a
password. I better notify the DBA and IT Professional.
Dear Database Administrator, Will you please reset
the passwords for the database portions of this
account?
Dear IT Professional, Will you please reset the
passwords for the IT components of this account?
I just received a request to reset the password for the
IT components of an account. I will do this now.
Dear Support Representative, The passwords for the
IT components of the new account have been reset.
I just received a request to reset the passwords for the
database components of an account. I will reset them
now.
Dear Support Representative, The passwords for the
database components of the account have been reset.
Yes, I will log a support ticket to
request a password reset
Great, I just received notice that
the password has been reset.
Dear End-User, Your password
has been reset.
Great, I have my new
password and can access
my clinical account again.
Dear Manager, The password has been reset for the
account..
Copyright © BioPharm Systems, Inc. 2012. All rights reserved
5/1/2013
Password Reset with Accel-Account Manager
Great, my password has
been reset and I can access
my account again.
Oops! I forgot my password. I will reset
it with Accel-Account Manager
Copyright © BioPharm Systems, Inc. 2012. All rights reserved
Accel-Account Manager for the Administrator
5/1/2013
• Create Clinical Accounts for OC, RDC, and TMS
• Update Clinical Accounts for OC, RDC, and TMS
• Apply Oracle Profile to account
• Grant database roles for an account
• Manage account access to multiple environments from a single page
Manage Accounts
• Reset passwords for several accounts at once
• Lock and disable one or more clinical accounts
Account Maintenance
• Generate Clinical Accounts en masse (from Excel Spreadsheet)
• Grant RDC Study Site Security for users en masse
• Revoke RDC Study Site Security for users en masse
En Masse Features
• Review complete log of account operations
• Review complete log of system generated emails
Logs
Copyright © BioPharm Systems, Inc. 2012. All rights reserved
Accel-Account Manager for the End User
5/1/2013
• Reset Password
• Set/Reset Security Questions
• Retrieve Username
Manage Account
• Customize Password
• Automatic Lockout after numerous invalid attempts to reset password, use credentials, etc.
Account Security Protection
• Automatic Notification of Account Credentials
• Automatic Notification of important changes being made to account
• Administrator is notified in case of an error with an account, such as an account is locked for excessive invalid attempts to use account
Automatic Notification
Copyright © BioPharm Systems, Inc. 2012. All rights reserved
Installation and Technology Stack
5/1/2013
Installed on Production Application
Server and in Production Database
(master) within own schema
Configured to control all other
connected environments (e.g. Test
and Dev) from single install
Technology Stack:
ActiveState Perl w/ ModPerl
Apache SSL Web Server
PL/SQL
Copyright © BioPharm Systems, Inc. 2012. All rights reserved