Unable to see encrypted data after a password change for a database user
2 years ago
Originally Published: 2008-04-28
Article Number
000061721
Applies To
RSA Database Security Manager 2.1
Oracle 10g Real Application Cluster ( RAC )
Microsoft Windows
All UNIX
Issue
Unable to see encrypted data after a password change for a database user
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
The keys of the user have become invalid and need to be regenerated.
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