CredentialStore.cc File Reference

#include "CondCore/CondDB/interface/CredentialStore.h"
#include "CondCore/CondDB/interface/Cipher.h"
#include "CondCore/CondDB/interface/Exception.h"
#include "CondCore/CondDB/interface/Auth.h"
#include "CoralBase/AttributeList.h"
#include "CoralBase/Attribute.h"
#include "CoralKernel/Context.h"
#include "CoralCommon/URIParser.h"
#include "RelationalAccess/AuthenticationCredentials.h"
#include "RelationalAccess/IBulkOperation.h"
#include "RelationalAccess/IConnection.h"
#include "RelationalAccess/ISession.h"
#include "RelationalAccess/IRelationalService.h"
#include "RelationalAccess/IRelationalDomain.h"
#include "RelationalAccess/ITransaction.h"
#include "RelationalAccess/ISchema.h"
#include "RelationalAccess/ITable.h"
#include "RelationalAccess/TableDescription.h"
#include "RelationalAccess/ITableDataEditor.h"
#include "RelationalAccess/ITablePrivilegeManager.h"
#include "RelationalAccess/IQuery.h"
#include "RelationalAccess/ICursor.h"
#include <filesystem>
#include <fstream>
#include <sstream>

Go to the source code of this file.

Classes
struct	cond::AuthorizationData
struct	cond::CredentialData
class	cond::CSScopedSession
struct	cond::PrincipalData

Namespaces
	cond

Functions
void	addSequence (coral::ISchema &schema, const std::string &name)
static const std::string	ADMIN_KEY_COL ("CRED2")
static const std::string	AUTH_ID_COL ("AUTH_ID")
static const std::string	AUTH_KEY_COL ("CRED3")
static const std::string	C_ID_COL ("C_ID")
static const std::string	COND_AUTHENTICATION_TABLE ("COND_AUTHENTICATION")
static const std::string	COND_AUTHORIZATION_TABLE ("COND_AUTHORIZATION")
static const std::string	COND_CREDENTIAL_TABLE ("COND_CREDENTIAL")
static const std::string	CONNECTION_ID_COL ("CONN_ID")
static const std::string	CONNECTION_KEY_COL ("CRED7")
static const std::string	CONNECTION_LABEL_COL ("CONN_LABEL")
const std::string	DEFAULT_DATA_SOURCE ("Cond_Default_Authentication")
bool	cond::getNextSequenceValue (coral::ISchema &schema, const std::string &sequenceName, int &value)
static const std::string	P_ID_COL ("P_ID")
static const std::string	PASSWORD_COL ("CRED5")
static const std::string	PRINCIPAL_ID_COL ("P_ID")
static const std::string	PRINCIPAL_KEY_COL ("CRED1")
static const std::string	PRINCIPAL_NAME_COL ("P_NAME")
static const std::string	ROLE_COL ("C_ROLE")
static const std::string	SCHEMA_COL ("C_SCHEMA")
std::string	cond::schemaLabel (const std::string &serviceName, const std::string &userName)
std::string	cond::schemaLabelForCredentialStore (const std::string &connectionString)
bool	cond::selectAuthorization (coral::ISchema &schema, int principalId, const std::string &role, const std::string &connectionString, AuthorizationData &destination)
bool	cond::selectConnection (coral::ISchema &schema, const std::string &connectionLabel, CredentialData &destination)
bool	cond::selectPrincipal (coral::ISchema &schema, const std::string &principal, PrincipalData &destination)
static const std::string	SEQUENCE_NAME_COL ("NAME")
static const std::string	SEQUENCE_TABLE_NAME ("COND_CREDENTIAL_SEQUENCE")
static const std::string	SEQUENCE_VALUE_COL ("VALUE")
bool	cond::setPermissionData (coral::ISchema &schema, int principalId, const std::string &principalKey, const std::string &role, const std::string &connectionString, int connectionId, const std::string &connectionKey, std::stringstream &log)
std::pair< int, std::string >	cond::updateConnectionData (coral::ISchema &schema, const std::string &adminKey, const std::string &connectionLabel, const std::string &userName, const std::string &password, bool forceUpdate, std::stringstream &log)
std::pair< int, std::string >	cond::updatePrincipalData (coral::ISchema &schema, const std::string &authenticationKey, const std::string &principalName, const std::string &adminKey, bool init, std::stringstream &log)
static const std::string	USERNAME_COL ("CRED4")
static const std::string	VERIFICATION_COL ("CRED0")
static const std::string	VERIFICATION_KEY_COL ("CRED6")

Variables
static const std::string	serviceName = "CondAuthenticationService"

Function Documentation

addSequence()

void addSequence	(	coral::ISchema &	schema,
		const std::string &	name
	)

Definition at line 741 of file CredentialStore.cc.

                                                              {
  // Create the entry in the table
  coral::AttributeList insertData;
  insertData.extend<std::string>(SEQUENCE_NAME_COL);
  insertData.extend<int>(SEQUENCE_VALUE_COL);
  coral::AttributeList::iterator iAttribute = insertData.begin();
  iAttribute->data<std::string>() = name;
  ++iAttribute;
  iAttribute->data<int>() = -1;
  schema.tableHandle(SEQUENCE_TABLE_NAME).dataEditor().insertRow(insertData);
}

References Skims_PA_cff::name, SEQUENCE_NAME_COL(), SEQUENCE_TABLE_NAME(), SEQUENCE_VALUE_COL(), and AlCaHLTBitMon_QueryRunRegistry::string.

Referenced by cond::CredentialStore::createSchema().

ADMIN_KEY_COL()

static const std::string ADMIN_KEY_COL ( "CRED2"  )

static

Referenced by cond::CredentialStore::createSchema(), cond::selectPrincipal(), and cond::updatePrincipalData().

AUTH_ID_COL()

static const std::string AUTH_ID_COL ( "AUTH_ID"  )

static

Referenced by cond::CredentialStore::createSchema(), cond::selectAuthorization(), and cond::setPermissionData().

AUTH_KEY_COL()

static const std::string AUTH_KEY_COL ( "CRED3"  )

static

Referenced by cond::CredentialStore::createSchema(), cond::CredentialStore::getUserCredentials(), cond::selectAuthorization(), cond::CredentialStore::selectForUser(), and cond::setPermissionData().

C_ID_COL()

static const std::string C_ID_COL ( "C_ID"  )

static

Referenced by cond::CredentialStore::createSchema(), cond::CredentialStore::exportAll(), cond::CredentialStore::getUserCredentials(), cond::CredentialStore::removeConnection(), cond::selectAuthorization(), cond::CredentialStore::selectForUser(), cond::CredentialStore::selectPermissions(), cond::setPermissionData(), and cond::CredentialStore::startSession().

COND_AUTHENTICATION_TABLE()

static const std::string COND_AUTHENTICATION_TABLE ( "COND_AUTHENTICATION"  )

static

Referenced by cond::CredentialStore::createSchema(), cond::CredentialStore::drop(), cond::CredentialStore::listPrincipals(), cond::CredentialStore::removePrincipal(), cond::CredentialStore::selectPermissions(), cond::selectPrincipal(), cond::CredentialStore::startSession(), and cond::updatePrincipalData().

COND_AUTHORIZATION_TABLE()

static const std::string COND_AUTHORIZATION_TABLE ( "COND_AUTHORIZATION"  )

static

Referenced by cond::CredentialStore::createSchema(), cond::CredentialStore::drop(), cond::CredentialStore::exportAll(), cond::CredentialStore::getUserCredentials(), cond::CredentialStore::removeConnection(), cond::CredentialStore::removePrincipal(), cond::selectAuthorization(), cond::CredentialStore::selectForUser(), cond::CredentialStore::selectPermissions(), cond::setPermissionData(), cond::CredentialStore::startSession(), and cond::CredentialStore::unsetPermission().

COND_CREDENTIAL_TABLE()

static const std::string COND_CREDENTIAL_TABLE ( "COND_CREDENTIAL"  )

static

Referenced by cond::CredentialStore::createSchema(), cond::CredentialStore::drop(), cond::CredentialStore::exportAll(), cond::CredentialStore::getUserCredentials(), cond::CredentialStore::listConnections(), cond::CredentialStore::removeConnection(), cond::selectConnection(), cond::CredentialStore::selectForUser(), cond::CredentialStore::selectPermissions(), cond::CredentialStore::startSession(), and cond::updateConnectionData().

CONNECTION_ID_COL()

static const std::string CONNECTION_ID_COL ( "CONN_ID"  )

static

Referenced by cond::CredentialStore::createSchema(), cond::CredentialStore::exportAll(), cond::CredentialStore::getUserCredentials(), cond::CredentialStore::removeConnection(), cond::selectConnection(), cond::CredentialStore::selectForUser(), cond::CredentialStore::selectPermissions(), cond::CredentialStore::startSession(), and cond::updateConnectionData().

CONNECTION_KEY_COL()

static const std::string CONNECTION_KEY_COL ( "CRED7"  )

static

Referenced by cond::CredentialStore::createSchema(), cond::CredentialStore::exportAll(), cond::CredentialStore::listConnections(), cond::selectConnection(), cond::CredentialStore::startSession(), and cond::updateConnectionData().

CONNECTION_LABEL_COL()

static const std::string CONNECTION_LABEL_COL ( "CONN_LABEL"  )

static

Referenced by cond::CredentialStore::createSchema(), cond::CredentialStore::exportAll(), cond::CredentialStore::getUserCredentials(), cond::CredentialStore::listConnections(), cond::selectConnection(), cond::CredentialStore::selectForUser(), cond::CredentialStore::selectPermissions(), cond::CredentialStore::startSession(), and cond::updateConnectionData().

DEFAULT_DATA_SOURCE()

const std::string DEFAULT_DATA_SOURCE

(

"Cond_Default_Authentication"

)

P_ID_COL()

static const std::string P_ID_COL ( "P_ID"  )

static

Referenced by cond::CredentialStore::createSchema(), cond::CredentialStore::getUserCredentials(), cond::CredentialStore::removePrincipal(), cond::selectAuthorization(), cond::CredentialStore::selectForUser(), cond::CredentialStore::selectPermissions(), cond::setPermissionData(), cond::CredentialStore::startSession(), and cond::CredentialStore::unsetPermission().

PASSWORD_COL()

static const std::string PASSWORD_COL ( "CRED5"  )

static

Referenced by cond::CredentialStore::createSchema(), cond::CredentialStore::exportAll(), cond::CredentialStore::getUserCredentials(), cond::CredentialStore::listConnections(), cond::selectConnection(), cond::CredentialStore::selectForUser(), cond::CredentialStore::startSession(), and cond::updateConnectionData().

PRINCIPAL_ID_COL()

static const std::string PRINCIPAL_ID_COL ( "P_ID"  )

static

Referenced by cond::CredentialStore::createSchema(), cond::CredentialStore::removePrincipal(), cond::CredentialStore::selectPermissions(), cond::selectPrincipal(), and cond::updatePrincipalData().

PRINCIPAL_KEY_COL()

static const std::string PRINCIPAL_KEY_COL ( "CRED1"  )

static

Referenced by cond::CredentialStore::createSchema(), cond::selectPrincipal(), and cond::updatePrincipalData().

PRINCIPAL_NAME_COL()

static const std::string PRINCIPAL_NAME_COL ( "P_NAME"  )

static

Referenced by cond::CredentialStore::createSchema(), cond::CredentialStore::listPrincipals(), cond::CredentialStore::selectPermissions(), cond::selectPrincipal(), and cond::updatePrincipalData().

ROLE_COL()

static const std::string ROLE_COL ( "C_ROLE"  )

static

Referenced by cond::CredentialStore::createSchema(), cond::CredentialStore::exportAll(), cond::CredentialStore::getUserCredentials(), cond::selectAuthorization(), cond::CredentialStore::selectForUser(), cond::CredentialStore::selectPermissions(), cond::setPermissionData(), cond::CredentialStore::startSession(), and cond::CredentialStore::unsetPermission().

SCHEMA_COL()

static const std::string SCHEMA_COL ( "C_SCHEMA"  )

static

Referenced by cond::CredentialStore::createSchema(), cond::CredentialStore::exportAll(), cond::CredentialStore::getUserCredentials(), cond::selectAuthorization(), cond::CredentialStore::selectForUser(), cond::CredentialStore::selectPermissions(), cond::setPermissionData(), cond::CredentialStore::startSession(), and cond::CredentialStore::unsetPermission().

SEQUENCE_NAME_COL()

static const std::string SEQUENCE_NAME_COL ( "NAME"  )

static

Referenced by addSequence(), cond::CredentialStore::createSchema(), and cond::getNextSequenceValue().

SEQUENCE_TABLE_NAME()

static const std::string SEQUENCE_TABLE_NAME ( "COND_CREDENTIAL_SEQUENCE"  )

static

Referenced by addSequence(), cond::CredentialStore::createSchema(), cond::CredentialStore::drop(), and cond::getNextSequenceValue().

SEQUENCE_VALUE_COL()

static const std::string SEQUENCE_VALUE_COL ( "VALUE"  )

static

Referenced by addSequence(), cond::CredentialStore::createSchema(), and cond::getNextSequenceValue().

USERNAME_COL()

static const std::string USERNAME_COL ( "CRED4"  )

static

Referenced by cond::CredentialStore::createSchema(), cond::CredentialStore::exportAll(), cond::CredentialStore::getUserCredentials(), cond::CredentialStore::listConnections(), cond::selectConnection(), cond::CredentialStore::selectForUser(), cond::CredentialStore::startSession(), and cond::updateConnectionData().

VERIFICATION_COL()

static const std::string VERIFICATION_COL ( "CRED0"  )

static

Referenced by cond::CredentialStore::createSchema(), cond::selectPrincipal(), and cond::updatePrincipalData().

VERIFICATION_KEY_COL()

static const std::string VERIFICATION_KEY_COL ( "CRED6"  )

static

Referenced by cond::CredentialStore::createSchema(), cond::CredentialStore::exportAll(), cond::CredentialStore::getUserCredentials(), cond::CredentialStore::listConnections(), cond::selectConnection(), cond::CredentialStore::selectForUser(), cond::CredentialStore::startSession(), and cond::updateConnectionData().

Variable Documentation

serviceName

const std::string serviceName = "CondAuthenticationService"

static

Definition at line 31 of file CredentialStore.cc.

Referenced by cond::auth::DecodingKey::addService(), cond::auth::DecodingKey::createFromInputFile(), cond::CredentialStore::importForPrincipal(), cond::persistency::parseConnectionString(), coral_bridge::AuthenticationCredentialSet::registerCredentials(), coral_bridge::AuthenticationCredentialSet::registerItem(), cond::schemaLabel(), cond::schemaLabelForCredentialStore(), cond::CredentialStore::setUpForConnectionString(), and cond::CredentialStore::setUpForService().