AyaNova service management & work order software
AyaNova Support Forum
Home       Members    Calendar    Who's On
Welcome Guest ( Login | Register )
        



Multiple databases? Expand / Collapse
Author
Message
Posted 9/7/2007 2:09:43 PM
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Group: Forum Members
Last Login: 2/25/2009 1:05:47 PM
Posts: 23, Visits: 72
Would it be possible to setup user logins which can only view certain items in "Preventive Maintenance" or "Services".  For example, our goal is to have one facilities manager on site at two or more different buildings.  When they login we do not want them to be able to see the other buildings workorders or PM information.  Also, every user for our company would need to be able to see/access workorders for each building.  Is there a way to do this in Ayanova? 

Thank you,

    Tory

Post #3406
Posted 9/8/2007 10:44:44 AM
AyaNova Sales & Support

AyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & Support

Group: Administrators
Last Login: Yesterday @ 6:04:54 PM
Posts: 2,018, Visits: 4,604
Hi Tory

Security in AyaNova is to set the ability for users to access features of AyaNova or not. For example, if you set up a security group to have read/write/delete access to Preventive Maintenance, than all users of that security group will have read/write/delete access to all preventive maintenance orders.

It is not possible to specify what preventive maintenance orders users of a security group can access

You could purchase licenses for two separate databases, this way users only log into the database that they are allowed to view data from.

- Joyce

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #3408
Posted 9/10/2007 6:04:19 AM
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Group: Forum Members
Last Login: 2/25/2009 1:05:47 PM
Posts: 23, Visits: 72
How would two databases run on one server? Could I have certain users/computers see multiple databases?

-Tory
Post #3409
Posted 9/10/2007 9:04:55 AM
AyaNova Sales & Support

AyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & Support

Group: Administrators
Last Login: Yesterday @ 6:04:54 PM
Posts: 2,018, Visits: 4,604
Hi again Tory

You would set AyaNova 3 up just as you would using two SQL databases on one SQL Server, or using two Firebird Server databases on one server.

A basic overview:

  • purchase licenses for each AyaNova database as each database must have its own licenses - see also the FAQ & Answers web page question http://www.ayanova.com/FAQAnswers.htm#I_will_be_using_multiple_databases_-_do_I_need_to_purchase_separate_licenses_for_each_database_
  • network configure first database
  • make copy of the original databasewith different name/locations
  • purchase licenses for first database and apply to first database
  • purchase licenses for second database and apply keycode to second database
  • for those users that would need access to both databases, you set up two AyaNova program folders each with its own AyaNova.exe.config pointing to a different database - otherwise for those that would only connect to one database, the user is setup with the config file that points to the specific database they require

Precise steps depend on:

  • what database server will be in use - SQL Express or SQL or Firebird,
  • what computers will be connecting to only one of the databases
  • what computers will be connecting to both databases
  • what optional add-ons (DataPortal, WBI, QBI, etc) are to be used with what database.
  • And through this all, as you are creating databases and moving them around etc, you need to ensure no one is accessing the database(s) while you initially set them up just as the instructions are when initially setting up one database.

If you want to post details on the above, I can provide specific instructions for your situation.

[DO NOTE: with AyaNova 4, confiugration is different due to simplified setup - refer to http://forum.ayanova.com/Topic3835-114-1.aspx]


- Joyce


AyaNova Sales & Technical Support
http://www.ayanova.com
Post #3410
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: AyaNova Sales & Support

Permissions Expand / Collapse

All times are GMT -8:00, Time now is 1:09am

Powered by InstantForum.NET v4.1.4 © 2009
Execution: 0.094. 10 queries. Compression Disabled.