Hi all,
As I was using the system, it seems, I did some thing and now I log on with the system administration account but I haven't privileges to do things as primary cataloguing, create a new patron etc. (see the screenshot below:) Obviously, it isn't system's fault but some thing I did wrong. How can I solve this? Thank you. |
Are you able to open
Administration -> Configure System -> Patron Categories? If yes, Select "System Administrator" category, click on privilege buttons (Right side of the screen). Check by giving all privileges. And click on "OK" to save it. Now close NewGenLib screen and open it again. If you are unable to open "Patron category" screen it self, send back a message, I will give a sql query to resolve the problem
NewGenLib Open Source Support
Verus Solutions Private Limited www.verussolutions.biz |
Yes, my first move was to try to give back the privileges from the patron category, but unfortunately I don't have access to this option.
Thanx. |
1. Open PgAdmin 3
2. Select newgenlib database. And click on SQL icon on top of your screen. This will open a sql window. Paste the below query in it update privilege set privilege = '<?xml version="1.0" encoding="UTF-8"?><privilege><ACQUISITION>Y</ACQUISITION><PROCESSREQUEST>Y</PROCESSREQUEST><RECORDREQUEST>Y</RECORDREQUEST><REFINEREQUEST>Y</REFINEREQUEST><PRNTTOAPPROVINGAUTH>Y</PRNTTOAPPROVINGAUTH><REQAPPROVALREJECTION>Y</REQAPPROVALREJECTION><SEARCHREQUEST>Y</SEARCHREQUEST><PROCESSONAPPROVAL>Y</PROCESSONAPPROVAL><RECORDONAPPROVAL>Y</RECORDONAPPROVAL><PRINTONAPPROVAL>Y</PRINTONAPPROVAL><IMPORTVENDORONAPPROVAL>Y</IMPORTVENDORONAPPROVAL><RECEIVEONAPPROVAL>Y</RECEIVEONAPPROVAL><PRINTLTRFORAPPROVAL>Y</PRINTLTRFORAPPROVAL><ONAPPROVALREJECTAPPROVE>Y</ONAPPROVALREJECTAPPROVE><SEARCHONAPPROVAL>Y</SEARCHONAPPROVAL><ACQFIRMORDERS>Y</ACQFIRMORDERS><ACQFIRMORDERS>Y</ACQFIRMORDERS><ACQPLACEFIRMORDERS>Y</ACQPLACEFIRMORDERS><ACQCANCELANDREORDER>Y</ACQCANCELANDREORDER><ACQPRINTFIRMORDERS>Y</ACQPRINTFIRMORDERS><ACQRECEIVEORDERS>Y</ACQRECEIVEORDERS><ACQDELETEINVOICE>Y</ACQDELETEINVOICE><ACQGIFTS>Y</ACQGIFTS><ACQSOLIGIFTS>Y</ACQSOLIGIFTS><ACQUNSOLIGIFTS>Y</ACQUNSOLIGIFTS><ACQSEEKGIFTS>Y</ACQSEEKGIFTS><ACQRECEIVEGIFTS>Y</ACQRECEIVEGIFTS><ACQVIEWGIFTS>Y</ACQVIEWGIFTS><ACQACCESSIONING>Y</ACQACCESSIONING><ACQDELETEACCESSION>Y</ACQDELETEACCESSION><ACQPROCESSPAYMENT>Y</ACQPROCESSPAYMENT><ACQROLLBACKPAYMENT>Y</ACQROLLBACKPAYMENT><ACQINVOICEPAYMENT>Y</ACQINVOICEPAYMENT><ACQCLAIMSUNSUPPLIED>Y</ACQCLAIMSUNSUPPLIED><TECHNICALPROCESSING>Y</TECHNICALPROCESSING><TECHITEMREADYFORCATALOGUE>Y</TECHITEMREADYFORCATALOGUE><TECHIMPORTCATALOGUE>Y</TECHIMPORTCATALOGUE><TECHOPENARCHIVE>Y</TECHOPENARCHIVE><TECHCATALOGUEFOROTHERLIB>Y</TECHCATALOGUEFOROTHERLIB><TECHPRIMARYCATALOGUING>Y</TECHPRIMARYCATALOGUING><TECHSIMPLEPRIMARYCATALOG>Y</TECHSIMPLEPRIMARYCATALOG><TECHGENERALPRIMARYCATALOG>Y</TECHGENERALPRIMARYCATALOG><TECHMARCPRIMARYCATALOG>Y</TECHMARCPRIMARYCATALOG><TECHMODIFYCATALOG>Y</TECHMODIFYCATALOG><TECHSIMPLEMODIFYCATALOG>Y</TECHSIMPLEMODIFYCATALOG><TECHGENERALMODIFYCATALOG>Y</TECHGENERALMODIFYCATALOG><TECHMARCMODIFYCATALOG>Y</TECHMARCMODIFYCATALOG><SEARCHCATALOGUE>Y</SEARCHCATALOGUE><UPDATEHOLDINGS>Y</UPDATEHOLDINGS><DELETECATALOGUE>Y</DELETECATALOGUE><DELETEANDAPPENDCATALOG>Y</DELETEANDAPPENDCATALOG><HARVESTINGOAIPMH>Y</HARVESTINGOAIPMH><CIRCULATION>Y</CIRCULATION><CIRCHECKOUTISSUE>Y</CIRCHECKOUTISSUE><CIRCANCHECKOUTDELINQISHUSER>Y</CIRCANCHECKOUTDELINQISHUSER><CIRCANCHECKOUTDELINQISHUSER>Y</CIRCANCHECKOUTDELINQISHUSER><CIRCHECKINISSUE>Y</CIRCHECKINISSUE><CIRCANOVERRIDEFINE>Y</CIRCANOVERRIDEFINE><CIRRESERVATION>Y</CIRRESERVATION><CIRPLACERESERVATION>Y</CIRPLACERESERVATION><CIRUPDATERESERVATION>Y</CIRUPDATERESERVATION><CIRCANCELRESERVATION>Y</CIRCANCELRESERVATION><CIRCHKILL>Y</CIRCHKILL><CIRPLACEILL>Y</CIRPLACEILL><CIRAPPROVEILL>Y</CIRAPPROVEILL><CIRINTEMATEILLPATRON>Y</CIRINTEMATEILLPATRON><CIRILLREQOTHERLIB>Y</CIRILLREQOTHERLIB><CIRDISPATCHILLDOCUMENT>Y</CIRDISPATCHILLDOCUMENT><CIRBINDINGMGMT>Y</CIRBINDINGMGMT><CIRIDENTIFYDOCTOBIND>Y</CIRIDENTIFYDOCTOBIND><CIRCHKOUTTOBINDER>Y</CIRCHKOUTTOBINDER><CIRCHKINBOUNDITEMS>Y</CIRCHKINBOUNDITEMS><CIRRENEWDOC>Y</CIRRENEWDOC><CIRRECALLDOCUMENT>Y</CIRRECALLDOCUMENT><CIRCOLLECTOVERDUES>Y</CIRCOLLECTOVERDUES><CIRREPORTEDLOSS>Y</CIRREPORTEDLOSS><CIRCHKWEEDOUT>Y</CIRCHKWEEDOUT><CIRIDENTFYINGWEEDOUT>Y</CIRIDENTFYINGWEEDOUT><CIRAPPROVEDWEEDOUT>Y</CIRAPPROVEDWEEDOUT><CIRAPPROVEDWEEDOUT>Y</CIRAPPROVEDWEEDOUT><JRNLMANAGEMENT>Y</JRNLMANAGEMENT><JRNLADDTOSUBSCRIPTION>Y</JRNLADDTOSUBSCRIPTION><JRNLSEARCHSUBSCRIPTION>Y</JRNLSEARCHSUBSCRIPTION><JRNLMODIFYSUBSCRIPTION>Y</JRNLMODIFYSUBSCRIPTION><JRNLDELETESUBSCRIPTION>Y</JRNLDELETESUBSCRIPTION><JRNLFIRMORDERS>Y</JRNLFIRMORDERS><JRNLPLACESUBSCRIPTION>Y</JRNLPLACESUBSCRIPTION><JRNLCANCELREORDERSERIAL>Y</JRNLCANCELREORDERSERIAL><JRNLPRINTSUBSCRIPTIONS>Y</JRNLPRINTSUBSCRIPTIONS><JRNLPRINTSUBSCRIPTIONS>Y</JRNLPRINTSUBSCRIPTIONS><JRNLRECEIVEINVOICE>Y</JRNLRECEIVEINVOICE><JRNLRECEIVEORDERS>Y</JRNLRECEIVEORDERS><JRNLSUPPLYMENTINVOICE>Y</JRNLSUPPLYMENTINVOICE><JRNLPAYMENTDETAILS>Y</JRNLPAYMENTDETAILS><JRNLBINDINGMGMT>Y</JRNLBINDINGMGMT><JRNLLOGICALLIST>Y</JRNLLOGICALLIST><JRNLPHYSICALLIST>Y</JRNLPHYSICALLIST><JRNLBINDORDERS>Y</JRNLBINDORDERS><JRNLRECEIVEBOUNDITEMS>Y</JRNLRECEIVEBOUNDITEMS><JRNLACCESSIONBOUND>Y</JRNLACCESSIONBOUND><JRNLBINDINVOICE>Y</JRNLBINDINVOICE><JRNLREGISTERISSUE>Y</JRNLREGISTERISSUE><JRNLRENEWSUBSCRIPTION>Y</JRNLRENEWSUBSCRIPTION><SYSTEMCONFIGURATION>Y</SYSTEMCONFIGURATION><ADMNPERSONALNAME>Y</ADMNPERSONALNAME><ADMNPERSONALNAMENEW>Y</ADMNPERSONALNAMENEW><ADMNSEARCHPERSONALNAME>Y</ADMNSEARCHPERSONALNAME><ADMNSEARCHCORPORATE>Y</ADMNSEARCHCORPORATE><ADMNSEARCHMEETING>Y</ADMNSEARCHMEETING><ADMNSEARCHUNIFORM>Y</ADMNSEARCHUNIFORM><ADMNSEARCHTOPICAL>Y</ADMNSEARCHTOPICAL><ADMNSEARCHGEOGRAPH>Y</ADMNSEARCHGEOGRAPH><ADMNSEARCHFORMGENRE>Y</ADMNSEARCHFORMGENRE><ADMNSEARCHPATRON>Y</ADMNSEARCHPATRON><ADMNPERSONALMODIFY>Y</ADMNPERSONALMODIFY><ADMNPERSONALDELETE>Y</ADMNPERSONALDELETE><ADMNPERSONALDELETEREPLACE>Y</ADMNPERSONALDELETEREPLACE><ADMNCORPORATE>Y</ADMNCORPORATE><ADMNCORPORATENEW>Y</ADMNCORPORATENEW><ADMNCORPORATEMODIFY>Y</ADMNCORPORATEMODIFY><ADMNCORPORATEMODIFY>Y</ADMNCORPORATEMODIFY><ADMNCORPORATEDELETE>Y</ADMNCORPORATEDELETE><ADMNCORPORATEDELETEREPLACE>Y</ADMNCORPORATEDELETEREPLACE><ADMNMEETING>Y</ADMNMEETING><ADMNMEETINGNEW>Y</ADMNMEETINGNEW><ADMNMEETINGMODIFY>Y</ADMNMEETINGMODIFY><ADMNMEETINGDELETE>Y</ADMNMEETINGDELETE><ADMNMEETINGDELETEREPLACE>Y</ADMNMEETINGDELETEREPLACE><ADMNUNTITLE>Y</ADMNUNTITLE><ADMNUNTITLENEW>Y</ADMNUNTITLENEW><ADMNUNTITLEMODIFY>Y</ADMNUNTITLEMODIFY><ADMNUNTITLEDELETE>Y</ADMNUNTITLEDELETE><ADMNUNTITLEDELETEREPLACE>Y</ADMNUNTITLEDELETEREPLACE><ADMNTOPICAL>Y</ADMNTOPICAL><ADMNTOPICALNEW>Y</ADMNTOPICALNEW><ADMNTOPICALMODIFY>Y</ADMNTOPICALMODIFY><ADMNTOPICALDELETE>Y</ADMNTOPICALDELETE><ADMNTOPICALDELETEREPLACE>Y</ADMNTOPICALDELETEREPLACE><ADMNGEONAME>Y</ADMNGEONAME><ADMNGEONAMENEW>Y</ADMNGEONAMENEW><ADMNGEONAMEMODIFY>Y</ADMNGEONAMEMODIFY><ADMNGEONAMEDELETE>Y</ADMNGEONAMEDELETE><ADMNGEONAMEDELETEREPLACE>Y</ADMNGEONAMEDELETEREPLACE><ADMNFORMGENRE>Y</ADMNFORMGENRE><ADMNFORMGENRENEW>Y</ADMNFORMGENRENEW><ADMNFORMGENREMODIFY>Y</ADMNFORMGENREMODIFY><ADMNFORMGENREDELETE>Y</ADMNFORMGENREDELETE><ADMNFORMGENREDELETEREPLACE>Y</ADMNFORMGENREDELETEREPLACE><ADMNPATRON>Y</ADMNPATRON><ADMNPATRONNEW>Y</ADMNPATRONNEW><ADMNPATRONMODIFY>Y</ADMNPATRONMODIFY><ADMNPATRONDELETE>Y</ADMNPATRONDELETE><ADMNPATRONDELIQUENT>Y</ADMNPATRONDELIQUENT><ADMNPATRONCHANGEPASSWORD>Y</ADMNPATRONCHANGEPASSWORD><ADMNBUDGETSOURCE>Y</ADMNBUDGETSOURCE><ADMNBUDGETSOURCENEW>Y</ADMNBUDGETSOURCENEW><ADMNBUDGETMODIFY>Y</ADMNBUDGETMODIFY><ADMNBUDGETDELETE>Y</ADMNBUDGETDELETE><ADMNBUDGETHEAD>Y</ADMNBUDGETHEAD><ADMNBUDGETHEADNEW>Y</ADMNBUDGETHEADNEW><ADMNBUDGETHEADMODIFY>Y</ADMNBUDGETHEADMODIFY><ADMNBUDGETHEADDELETE>Y</ADMNBUDGETHEADDELETE><ADMNBUDGETAMOUNT>Y</ADMNBUDGETAMOUNT><ADMNBUDGETALLOCATE>Y</ADMNBUDGETALLOCATE><ADMNBUDGETMODIFYAMOUNT>Y</ADMNBUDGETMODIFYAMOUNT><ADMNBUDGETALLOCATEDELETE>Y</ADMNBUDGETALLOCATEDELETE><ADMNCURRENCYNAME>Y</ADMNCURRENCYNAME><ADMNCURRENCYNEW>Y</ADMNCURRENCYNEW><ADMNCURRNECYMODIFY>Y</ADMNCURRNECYMODIFY><ADMNCURRENCYDELETE>Y</ADMNCURRENCYDELETE><ADMNFISCALYEAR>Y</ADMNFISCALYEAR><ADMNFISCALNEW>Y</ADMNFISCALNEW><ADMNFISCALMODIFY>Y</ADMNFISCALMODIFY><ADMNFISCALDELETE>Y</ADMNFISCALDELETE><ADMNLOCATION>Y</ADMNLOCATION><ADMNLOCATIONNEW>Y</ADMNLOCATIONNEW><ADMNLOCATIONMODIFY>Y</ADMNLOCATIONMODIFY><ADMNLOCATIONDELETE>Y</ADMNLOCATIONDELETE><ADMNVENDOR>Y</ADMNVENDOR><ADMNVENDORNEW>Y</ADMNVENDORNEW><ADMNVENDORMODIFY>Y</ADMNVENDORMODIFY><ADMNVENDORDELETE>Y</ADMNVENDORDELETE><ADMNDEPT>Y</ADMNDEPT><ADMNDEPTNEW>Y</ADMNDEPTNEW><ADMNDEPTMODIFY>Y</ADMNDEPTMODIFY><ADMNDEPTDELETE>Y</ADMNDEPTDELETE><ADMNCOURCE>Y</ADMNCOURCE><ADMNCOURCENEW>Y</ADMNCOURCENEW><ADMNCOURCEMODIFY>Y</ADMNCOURCEMODIFY><ADMNCOURCEDELETE>Y</ADMNCOURCEDELETE><ADMNBINDER>Y</ADMNBINDER><ADMNBINDERNEW>Y</ADMNBINDERNEW><ADMNBINDERMODIFY>Y</ADMNBINDERMODIFY><ADMNBINDERDELETE>Y</ADMNBINDERDELETE><ADMNCIRCULATION>Y</ADMNCIRCULATION><ADMNCIRCULATIONNEW>Y</ADMNCIRCULATIONNEW><ADMNCIRCULATIONMODIFY>Y</ADMNCIRCULATIONMODIFY><ADMNCIRCULATIONDELETE>Y</ADMNCIRCULATIONDELETE><ADMNBINDTYPES>Y</ADMNBINDTYPES><ADMNBINDTYPESNEW>Y</ADMNBINDTYPESNEW><ADMNBINDTYPESMODIFY>Y</ADMNBINDTYPESMODIFY><ADMNBINDTYPESDELETE>Y</ADMNBINDTYPESDELETE><ADMNSERIALBOUND>Y</ADMNSERIALBOUND><ADMNSERIALBOUNDNEW>Y</ADMNSERIALBOUNDNEW><ADMNSERIALBOUNDMODIFY>Y</ADMNSERIALBOUNDMODIFY><ADMNSERIALBOUNDDELETE>Y</ADMNSERIALBOUNDDELETE><ADMNAUTONOGEN>Y</ADMNAUTONOGEN><ADMNAUTONOGENNEW>Y</ADMNAUTONOGENNEW><ADMNAUTONOGENMODIFY>Y</ADMNAUTONOGENMODIFY><ADMNAUTONOGENDELETE>Y</ADMNAUTONOGENDELETE><ADMNGENERALSETUPPARM>Y</ADMNGENERALSETUPPARM><ADMNFORMLETTERSEDITING>Y</ADMNFORMLETTERSEDITING><ADMNHOLIDAYLIST>Y</ADMNHOLIDAYLIST><ADMNACCESSIONSERIES>Y</ADMNACCESSIONSERIES><ADMNSEARCHBUDGETSOURCE>Y</ADMNSEARCHBUDGETSOURCE><ADMNSEARCHBUDGETHEAD>Y</ADMNSEARCHBUDGETHEAD><ADMNBUDGETHEADTRANSFER>Y</ADMNBUDGETHEADTRANSFER><ADMNUPDATEALLOCATION>Y</ADMNUPDATEALLOCATION><ADMNSEARCHBUDGETAMOUNT>Y</ADMNSEARCHBUDGETAMOUNT><ADMNSEARCHLOCATION>Y</ADMNSEARCHLOCATION><ADMNSEARCHVENDOR>Y</ADMNSEARCHVENDOR><ADMNTOOPSTORIES>Y</ADMNTOOPSTORIES><ADMNDATASOURCE>Y</ADMNDATASOURCE><ADMNSRUSERVER>Y</ADMNSRUSERVER><ADMNMARCTEMPLATE>Y</ADMNMARCTEMPLATE><ADMNPATRONCATEGORY>Y</ADMNPATRONCATEGORY><ADMNUPDATELIBRARYDETAILS>Y</ADMNUPDATELIBRARYDETAILS><ADMNCUSTOMINDEXES>Y</ADMNCUSTOMINDEXES><ADMNPUBLISHER>Y</ADMNPUBLISHER><ADMNPUBLISHERNEW>Y</ADMNPUBLISHERNEW><ADMNPUBLISHERMODIFY>Y</ADMNPUBLISHERMODIFY><ADMNPUBLISHERDELETE>Y</ADMNPUBLISHERDELETE><ADMNPUBLISHERSEARCH>Y</ADMNPUBLISHERSEARCH></privilege>'; Now click on the Green arrow button (Execute). Now close NewGenLib client and open it again
NewGenLib Open Source Support
Verus Solutions Private Limited www.verussolutions.biz |
In reply to this post by nsid
user.sql
Or download the above file and execute in pgadmin3
NewGenLib Open Source Support
Verus Solutions Private Limited www.verussolutions.biz |
It worked.
Thank you very much for the immediate response! |
|
Wordpad.exe resides in
C:\Program Files\Windows NT\Accessories Make sure you use file browsing facility to select the above exe file On 08/23/2011 10:24 AM, basediag [via NewGenLib] wrote:
NewGenLib Open Source Support
Verus Solutions Private Limited www.verussolutions.biz |
In reply to this post by nsid
how to solve this problom data entery sheet search itam attached one image file please guide sir.
fonts smaal, and spure box, this problom solve please |
Hi,
Can you explain the problem more clearly. Please attach screen shots so that the problem can be easily be understood On 09/03/2011 11:45 AM, mallikarjuna [via NewGenLib] wrote: how to solve this problom data entery sheet search itam attached one image file please guide sir.
NewGenLib Open Source Support
Verus Solutions Private Limited www.verussolutions.biz |
Free forum by Nabble | Edit this page |