Unable to see encrypted data after a password change for a database user
Originally Published: 2008-04-28
Last Modified: 2023-09-24
Article Number
Applies To
Oracle 10g Real Application Cluster ( RAC )
Microsoft Windows
All UNIX
Issue
After the password of a database user is changed (s)he is no longer able to view encrypted data.
NO ACCESS is shown for the encrypted columns.
Cause
Resolution
Whenever the password of a database user is changed, you will need to create a new set of keys to an existing user(s). In order to assign new set of keys to existing users, you can use Reconfigure User option.
Reconfigure the users in the following ways;
Reconfigure a single user.
Reconfigure all users in a role
Reconfigure all users of all roles
In order to use this option, simply right click on a user or role and click Reconfigure Users. To reconfigure all users of entire roles right click on the Role Node and click Reconfigure all Users.
Notes
See also: RSA DBSM Oracle Adapter Guide Chapter 4 -> Setting Access Privileges -> Managing Roles
Related Articles
Unable to see quick links solution tabs or navigation menu after signing in with SSO 90Number of Views Unable to see orgs after in place upgrade from 5.7.3 to 6.0.2.1 SP2 15Number of Views Allowing a non-administrative user to see the monitoring screen IMG: Aveksa Monitoring page 17Number of Views Users are able to see each other softoken in RSA SecurID token application in Citrix environment 9Number of Views RSA Authentication Manager 8.2 Token Management Snap-In for MMC Readme 72Number of Views
Trending Articles
RSA Authentication Manager 8.9 Patches and Hotfixes Readme RSA Authentication Manager 8.9 Setup and Configuration Guide RSA Authentication Manager 8.9 Release Notes (January 2026) RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device
Don't see what you're looking for?