Use the following procedure to replace an authorization.
Replacing an authorization allows the authorization definition to change without having to recompile any UDFs or XSPs that reference this authorization. Recompiling is required if an authorization is dropped and then created.
1 From the main window, click Tools > Administer > Authorizations.
2 Select the database or user in the Database Name field.
3 Enter the authorization name.
4 Click Display to view the current definition.
5 Change the User Name, Password, and Comment.
Note: Type the complete password. Do not use the Paste command in the Password field. Do not use the arrow keys or the mouse to navigate in the Password field.
6 Click Replace.
The status bar indicates the authorization has been replaced.