• Article Type: General
• Product: Aleph
• Product Version: 18.01

Description:
During our implementation, a library (ABC15) was created then deleted from our system; however, privileges were added to users' accounts before the library was deleted. Therefore, a majority of user accounts on our system list this non-existent library in the summary of privileges. When I try to enter ABC15 after clicking the Access Rights button, the system (correctly) informs me that ABC15 doesn't exist.

In order to simplify privileges (and possibly stave off problems for when we upgrade to later versions), I'd like to remove these bogus privileges.

DELETE FROM Z67 WHERE Z67_LIBRARY = 'NYU15';

Is it OK to run that statement, providing that no such library exists on our system?

Resolution:
Yes, it should be OK to do this.

You should back up the z67 first, using p_file_03. The job would be run in the $pw_library (which is where the z67 resides).

• Article last edited: 10/8/2013