Follow

How can update an Organization name in the Password Server

There may be times when you would like to update the Organization names in the Password Server.

Updating the Organization name requires a SQL Database change, we can make this change using SQL Management Studio.

Note: If need to install SQL Management Studio please try this link

 

Step 1

Open a New Query in SQL Management Studio

newquery.png

 

To update the OrgName in dbo.OrganizationTable we first need to disable the trigger.  Copy and paste the following in to the New Query Window.

USE [AuthAnvilPasswordServer]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

--Drop OrganizationTable Triggers

IF EXISTS (SELECT * FROM sys.triggers WHERE object_id = OBJECT_ID(N'[dbo].[TR_OrgTableBlock]'))

DROP TRIGGER [dbo].[TR_OrgTableBlock]

--Clear OrganizationTable

DELETE FROM [AuthAnvilPasswordServer].[dbo].[OrganizationTable]

where OrgName = ''

GO

 

Step 2

With the Trigger dropped you can now update the Organization Name in dbo.OrganizationTable.
You can do this by Selecting Edit Top 200 rows on dbo.OrganizationTable.

org.png


In Edit Mode we can update the OrgName field.
orgs.png

 

Step 3

Once we have the OrgName update complete we need to recreate the trigger. This is done by copy and pasting the following in a New Query.

--Create OrganizationTable Triggers

CREATE TRIGGER [dbo].[TR_OrgTableBlock]

ON [AuthAnvilPasswordServer].[dbo].[OrganizationTable]

FOR INSERT, UPDATE, DELETE

AS

IF OBJECT_ID('tempdb..#Disable') IS NOT NULL RETURN

 PRINT 'Trigger Executed'

 ROLLBACK TRAN

 RAISERROR ('You cannot directly access this table. Please use the stored procedures',14,1);

GO

 

 You can verify the the Organization name is correctly entered by navigating to https://(your domain)/AAPS and checking the Orgnizaiton list drop down menu.

 

 

Questions?

If you have any questions or need some help, we would be happy to assist. Open a case at help.scorpionsoft.com or send an email to support@scorpionsoft.com.

 

 

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk