Topics for Database Administrators |
The master password holder (usually, the DBA) can change any database password at any time. If a password that is stored in a view descriptor is changed, the DBA can either change the view descriptor or override the stored password each time the view descriptor is used. The software does not require that you use the same password. The engine only requires that you use a password that has enough authority to service the view descriptor.
Because SYSTEM 2000 passwords are not stored in access descriptors, there are no effects if a SYSTEM 2000 password is changed. Passwords can be stored in view descriptors, but changing a password does not affect the view descriptor. It still has all the items, but you might not be able to use the view. Nothing is automatically changed in the descriptors when you change a password or its authorities.
Copyright © 2007 by SAS Institute Inc., Cary, NC, USA. All rights reserved.